ISDS 3003 Final Exam Review
Questions and Answers
Business Intelligence (BI) reporting systems can do which of the following operations?
A. Filter data
B. Group data
C. Modify data
D. Both Filter data and Group data
E. Secure data - ANSWER-Both Filter data and Group data
A relational database stores data in the form of ________
A. forms
B. tables
C. lists
D. columns
E. spreadsheets - ANSWER-tables
A relational database is ________
A. a self-describing collection of related tables
B. a library of queries and data files for querying
C. a set of applications and the data sets for those applications
D. a set of metadata
E. a collection of forms and reports that support a given purpose - ANSWER-a self-
describing collection of related tables
Data mining applications are used to accomplish all of the following tasks except
________
, A. incorporate results into some other report/system
B. facilitate decision making
C. classify entities
D. make predictions
E. perform what-if analysis - ANSWER-classify entities
SQL stands for ________
A. Standard Question Language
B. Structural Question Language
C. Structured Query Language
D. Structured Question Language
E. Standard Query Language - ANSWER-Structured Query Language
Which of the following is not true about null values?
A. A null value can mean that no value for the field is appropriate.
B. A null value is ambiguous.
C. A null value can mean that the value is unknown.
D. Null values cannot be avoided.
E. A null value can mean that the value is known to be blank - ANSWER-Null values
cannot be avoided
Which of the following terms is synonymous with "relation"?
A. Row
B. Record
C. Table
D. Tuple
E. Attribute - ANSWER-Table
Questions and Answers
Business Intelligence (BI) reporting systems can do which of the following operations?
A. Filter data
B. Group data
C. Modify data
D. Both Filter data and Group data
E. Secure data - ANSWER-Both Filter data and Group data
A relational database stores data in the form of ________
A. forms
B. tables
C. lists
D. columns
E. spreadsheets - ANSWER-tables
A relational database is ________
A. a self-describing collection of related tables
B. a library of queries and data files for querying
C. a set of applications and the data sets for those applications
D. a set of metadata
E. a collection of forms and reports that support a given purpose - ANSWER-a self-
describing collection of related tables
Data mining applications are used to accomplish all of the following tasks except
________
, A. incorporate results into some other report/system
B. facilitate decision making
C. classify entities
D. make predictions
E. perform what-if analysis - ANSWER-classify entities
SQL stands for ________
A. Standard Question Language
B. Structural Question Language
C. Structured Query Language
D. Structured Question Language
E. Standard Query Language - ANSWER-Structured Query Language
Which of the following is not true about null values?
A. A null value can mean that no value for the field is appropriate.
B. A null value is ambiguous.
C. A null value can mean that the value is unknown.
D. Null values cannot be avoided.
E. A null value can mean that the value is known to be blank - ANSWER-Null values
cannot be avoided
Which of the following terms is synonymous with "relation"?
A. Row
B. Record
C. Table
D. Tuple
E. Attribute - ANSWER-Table
