ISDS 3003 FINAL QUESTIONS AND ANSWERS WITH
COMPLETE SOLUTION.
Regarding Big Data, what does the term NoSQL really mean?
A. No SQL used
B. Notational Query Language
C. Non-Blocking Query Language
D. NortonOS Query Language
E. Nonrelational Database Answer - E. Nonrelational Database
What role does the Web browser play in a Web database application?
A. Hardware support
B. Bug-reporting System
C. Web user interface
D. Microchip accelerator
E. Back-end Database Management System Answer - C. Web user interface
A relational database is:
A. a collection of forms and reports that support a given purpose
B. a set of metadata
C. a self-describing collection of related tables
D. a library of queries and data files for querying
,E. a set of applications and the data sets for those applications Answer - C. a
self-describing collection of related tables
Which of the following would not be an example of database metadata?
A. Properties of columns
B. Queries against records in the database tables
C. Properties of tables in a database
D. Names of tables in a database
E. Names of columns in a database and their associated tables Answer - B.
Queries against records in the database tables
The creation of a database and its tables is a function of which component of
the database system?
A. DBMS
B. Users
C. Application
D. Web server
E. Database Answer - A. DBMS
Microsoft SQL server is an example of a:
A. database management system
B. list manager
C. table
D. data manipulation system
E. database Answer - A. database management system
A relational database stores data in the form of:
, A. tables
B. lists
C. columns
D. forms
E. spreadsheets Answer - A. tables
SQL stands for:
A. Structured Question Language
B. Standard Question Language
C. Structural Question Language
D. Structured Query Language
E. Standard Query Language Answer - D. Structured Query Language
The Microsoft Access 2019 data type of AutoNumber is used when there is a
specific need for a:
A. primary key
B. secondary key
C. spare key
D. surrogate key
E. foreign key Answer - D. surrogate key
Which of the following problems associated with storing data in a list is avoided
by storing data in a relational database?
A. Duplication of data items
B. Incorrect data typing
C. Lack of necessary bandwidth
D. Running out of memory storage
COMPLETE SOLUTION.
Regarding Big Data, what does the term NoSQL really mean?
A. No SQL used
B. Notational Query Language
C. Non-Blocking Query Language
D. NortonOS Query Language
E. Nonrelational Database Answer - E. Nonrelational Database
What role does the Web browser play in a Web database application?
A. Hardware support
B. Bug-reporting System
C. Web user interface
D. Microchip accelerator
E. Back-end Database Management System Answer - C. Web user interface
A relational database is:
A. a collection of forms and reports that support a given purpose
B. a set of metadata
C. a self-describing collection of related tables
D. a library of queries and data files for querying
,E. a set of applications and the data sets for those applications Answer - C. a
self-describing collection of related tables
Which of the following would not be an example of database metadata?
A. Properties of columns
B. Queries against records in the database tables
C. Properties of tables in a database
D. Names of tables in a database
E. Names of columns in a database and their associated tables Answer - B.
Queries against records in the database tables
The creation of a database and its tables is a function of which component of
the database system?
A. DBMS
B. Users
C. Application
D. Web server
E. Database Answer - A. DBMS
Microsoft SQL server is an example of a:
A. database management system
B. list manager
C. table
D. data manipulation system
E. database Answer - A. database management system
A relational database stores data in the form of:
, A. tables
B. lists
C. columns
D. forms
E. spreadsheets Answer - A. tables
SQL stands for:
A. Structured Question Language
B. Standard Question Language
C. Structural Question Language
D. Structured Query Language
E. Standard Query Language Answer - D. Structured Query Language
The Microsoft Access 2019 data type of AutoNumber is used when there is a
specific need for a:
A. primary key
B. secondary key
C. spare key
D. surrogate key
E. foreign key Answer - D. surrogate key
Which of the following problems associated with storing data in a list is avoided
by storing data in a relational database?
A. Duplication of data items
B. Incorrect data typing
C. Lack of necessary bandwidth
D. Running out of memory storage
