Chapter 1 Quiz

Question 1

Which of the following is not a disadvantage of DBMS:
a. Increased costs
b. Management complexity
c. Vendor dependency
d. Data integration

Answer 1

data integration

Question 2

Which of the following is not a valid statement?
a. A database that is designed primarily to support a company’s day-to-day operations is classified as an operational 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. Production databases focus primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making.
d. The data warehouse is a specialized database that stores data in a format optimized for decision support.

Answer 2

c

Question 3

What are the components of database systems?

Answer 3

hardware, software, people, procedures, data

Question 4

Which of the following is not a valid statement?
a. Raw data is the collection of processed knowledge.
b. A database is a shared, integrated computer structure that stores a collection of user data and metadata.
c. Data redundancy exists when the same data is stored unnecessarily at different places.
d. Database design refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.

Answer 4

a

Question 5

Which of the following statements is true?
a. A DBMS is knowledge database management software.
b. A DBMS allows the user access to the database’s internal complexity.
c. A DBMS is a collection of programs that manage metadata data.
d. A DBMS is a set of processes that manage and control access to data stored in the database.

Answer 5

d

Question 6

Which of the following is not a function of a DBMS?
a. Data storage management
b. Data presentation management
c. Security management
d. User management

Answer 6

d

Question 7

Which of the following statements best defines a record?

Answer 7

a set of logically connected fields

Question 8

Which of the following lists problems with file system data processing?

Answer 8

development complexity, administration complexity, and lack of security

Question 9

Which of the following is not an advantage of a DBMS?
a. Data security
b. Data consistency
c. Data retrieval
d. Complexity

Answer 9

complexity

Question 10

What is the result of redundant data in the database?

Answer 10

data anomalies that lead to data inconsistencies