Assignment: Quiz: Chapter 01 Database Systems

Which of the following statements is true?

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

b. A DBMS is knowledge database management software.

c. A DBMS is a collection of programs that manage metadata data.

d. A DBMS allows the user access to the database's internal complexity. Which of the following is not an advantage of a DBMS? a. Data retrieval b. Data consistency c. Data security d. Complexity What is the result of redundant data in the database? a. Increased data security that leads to data access b. Lack of data sharing among database users c. Enforced data integrity that lead to data anomalies d. Data anomalies that lead to data inconsistencies What are the components of database systems? a. Software, personnel, procedures, data b. System, personnel, programs, data c. Hardware, software, people, procedures, data d. Hardware, system, people, programs, data Which of the following statements best defines a record? a. A record is a collection of fields. b. A record is a collection of data in files. c. A record is a set of logically connected fields d. A record is sets of data in related files. Which of the following is not a disadvantage of DBMS? a. Increased costs b. Management complexity c. Vendor dependency d. Data integration Which of the following is not a function of a DBMS? a. User management b. Data presentation management c. Data storage management d. Security management Which of the following is not a valid statement? a. Raw data is the collection of processed knowledge. b. 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. c. A database is a shared, integrated computer structure that stores a collection of user data and metadata. d. Data redundancy exists when the same data is stored unnecessarily at different places. Which of the following is not a valid statement? a. 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. b. A database that is designed primarily to support a company's day-to-day operations is classified as an operational database. c. The data warehouse is a specialized database that stores data in a format optimized for decision support. d. Production databases focus primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making.

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

a. Administration simplicity, answers simplicity, and lack of security

b. Administration simplicity, security complexity, and answers simplicity

c. Development complexity, administration complexity, and answers complexity

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

for additional queries:

https://quizlet.com/776292667/isys-4283-exam-1-flash-cards/