DATABASE SYSTEMS (CORONEL) FINAL REVIEW EXAM –
COMPLETE REAL EXAM QUESTIONS, ANSWERS, AND KEY
DATABASE CONCEPTS || CURRENTLY TESTING
1. What is the overarching process that focuses on data collection, storage, and retrieval,
including functions like addition, deletion, and modification?
A) Database Management System (DBMS)
B) Data Management
C) Business Intelligence
D) Query Processing
Answer ✔✔: B) Data Management
2. A shared, integrated computer structure that houses a collection of related data is known
as a:
A) Spreadsheet
B) Metadata Repository
C) Database
D) DBMS
Answer ✔✔: C) Database
3. What is the term for "data about data," which describes the structure, characteristics,
and usage of data in a database?
A) Data Dictionary
B) Metadata
C) Schema
D) Subschema
Answer ✔✔: B) Metadata
4. Which of the following is the collection of programs that manages the database structure
and controls access to the data stored in the database?
A) Operating System
, B) Database Management System (DBMS)
C) Data Management Language (DML)
D) Business Intelligence Suite
Answer ✔✔: B) Database Management System (DBMS)
5. A condition in which different versions of the same data yield different results is called:
A) Data Redundancy
B) Data Anomaly
C) Data Inconsistency
D) Referential Integrity Violation
Answer ✔✔: C) Data Inconsistency
6. A specific request for data manipulation issued by an end user to the DBMS, often in the
form of SQL code, is a:
A) Transaction
B) Query
C) Schema
D) Metadata request
Answer ✔✔: B) Query
7. A database that supports only one user at a time is known as a:
A) Workgroup Database
B) Multiuser Database
C) Single-User Database
D) Enterprise Database
Answer ✔✔: C) Single-User Database
8. Which type of database usually supports fewer than 50 users or is used for a specific
department in an organization?
A) Enterprise Database
B) Workgroup Database
C) Centralized Database
COMPLETE REAL EXAM QUESTIONS, ANSWERS, AND KEY
DATABASE CONCEPTS || CURRENTLY TESTING
1. What is the overarching process that focuses on data collection, storage, and retrieval,
including functions like addition, deletion, and modification?
A) Database Management System (DBMS)
B) Data Management
C) Business Intelligence
D) Query Processing
Answer ✔✔: B) Data Management
2. A shared, integrated computer structure that houses a collection of related data is known
as a:
A) Spreadsheet
B) Metadata Repository
C) Database
D) DBMS
Answer ✔✔: C) Database
3. What is the term for "data about data," which describes the structure, characteristics,
and usage of data in a database?
A) Data Dictionary
B) Metadata
C) Schema
D) Subschema
Answer ✔✔: B) Metadata
4. Which of the following is the collection of programs that manages the database structure
and controls access to the data stored in the database?
A) Operating System
, B) Database Management System (DBMS)
C) Data Management Language (DML)
D) Business Intelligence Suite
Answer ✔✔: B) Database Management System (DBMS)
5. A condition in which different versions of the same data yield different results is called:
A) Data Redundancy
B) Data Anomaly
C) Data Inconsistency
D) Referential Integrity Violation
Answer ✔✔: C) Data Inconsistency
6. A specific request for data manipulation issued by an end user to the DBMS, often in the
form of SQL code, is a:
A) Transaction
B) Query
C) Schema
D) Metadata request
Answer ✔✔: B) Query
7. A database that supports only one user at a time is known as a:
A) Workgroup Database
B) Multiuser Database
C) Single-User Database
D) Enterprise Database
Answer ✔✔: C) Single-User Database
8. Which type of database usually supports fewer than 50 users or is used for a specific
department in an organization?
A) Enterprise Database
B) Workgroup Database
C) Centralized Database
