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
,ISDS 3003 FINAL QUESTIONS AND ANSWERS WITH COMPLETE SOLUTION.
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
, ISDS 3003 FINAL QUESTIONS AND ANSWERS WITH COMPLETE SOLUTION.
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
E. CPU processing inefficiencies - (answer)A. Duplication of data items
Which of the following terms is synonymous with "tuple"?
A. Field
B. Relation
C. Row
D. Attribute
E. Table - (answer)C. Row
A key that contains more than one attribute is called a:
A. candidate key
B. complex key
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
,ISDS 3003 FINAL QUESTIONS AND ANSWERS WITH COMPLETE SOLUTION.
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
, ISDS 3003 FINAL QUESTIONS AND ANSWERS WITH COMPLETE SOLUTION.
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
E. CPU processing inefficiencies - (answer)A. Duplication of data items
Which of the following terms is synonymous with "tuple"?
A. Field
B. Relation
C. Row
D. Attribute
E. Table - (answer)C. Row
A key that contains more than one attribute is called a:
A. candidate key
B. complex key
