Module 1 Quiz

Which of the following is not a true statement? a. A database that is designed primarily to support a company's day-to-day operations is classified as an analytical database. b. Online analytical processing is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse. c. The data warehouse is a specialized database that stores data in a format optimized for decision support. d. Analytical database focuses primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making.

a. A database that is designed primarily to support a company's day-to-day operations is classified as an analytical database.

What are the components of database systems? a. Hardware, software, people, procedures, data b. Hardware, system, people, programs, data c. System, personnel, programs, data d. Software, personnel, procedures, data

a. Hardware, software, people, procedures, data

Which of the following statements best defines a record? a. A record is a collection of fields. b. A record is a set of related fields. c. A record is a set of data in related files. d. A record is collection of data in files.

b. A record is a set of related fields.

Which of the following lists problems with file system data processing? a. Development complexity, administration complexity, and answers complexity b. Development complexity, administration complexity, and lack of security c. Administration simplicity, security complexity, and answers simplicity d. Administration simplicity, answers simplicity, and lack of security

b. Development complexity, administration complexity, and lack of security

Which of the following is not a function of DBMS? a. Metadata management b. Performance tuning c. Security management d. Data presentation management

b. Performance tuning

Which of the following statements is true? a. DBMS is Database Management Software. b. DBMS is a collection of programs that manages metadata. c. DBMS is a set of processes that manage and control access to data stored in the database. d. All of the above e. None of the above

c. DBMS is a set of processes that manages and control access to data stored in the database.

What is the result of redundant data in the database? a. Lack of data sharing among database users b. Increased data security that leads to data access c. Data anomalies that lead to data inconsistency d. Enforced data integrity that leads to data anomalies

c. Data anomalies that lead to data inconsistency

Which of the following is an advantage of DBMS? a. Data consistency b. Data security c. Data retrieval d. All of the above e. None of the above

d. All of the above

Which of the following is not a disadvantage of database systems? a. Increased costs b. Management complexity c. Vendor dependency d. Infrequent upgrades

d. Infrequent upgrades