Database Systems Quiz

What is the primary function of a Database Management System (DBMS)?

• To eliminate the need for data security

• To store data in a manual system

• To manage the database structure and control access to data

• To create spreadsheets for data analysis

Which of the following is NOT an advantage of using a DBMS?

• Improved decision making

• Better data integration

• Increased data redundancy

• Improved data sharing

What type of database supports only one user at a time?

• Multiuser database

• Enterprise database

• Workgroup database

• Single-user database

Which type of database is designed primarily to support a company's day-to-day operations?

• Cloud database

• Centralized database

• Operational database

• Analytical database

What is metadata?

• Data about data that helps manage end-user data

• Data that has been processed to reveal its meaning

• Raw facts of interest to the end user

• Data stored in a cloud environment

Which of the following describes data inconsistency?

• Data that is secure and well-managed

• Data that is easily accessible

• Different versions of the same data appearing in different places

• Data stored in multiple locations

What is the first step in constructing a physical database?

• Transforming attributes into columns

• Transforming entities into tables

• Transforming relationships into primary keys

• Transforming domains into data types

Which of the following is a characteristic of structural independence?

• Data access is affected by data redundancy

• Changes in the database schema affect data access

• Changes in the database schema do not affect data access

• Data representation is dependent on physical storage

What is a cloud database?

• A database that supports only one user

• A database that supports data located at a single site

• A database created and maintained using cloud services

• A database focused on historical data

What is a major problem associated with file systems?

• Lengthy development times

• Easy data sharing

• Improved data security

• Quick data retrieval