University of Phoenix BIS/245 Database
Essentials Final Exam Practice
Examination 2026–2027 | Comprehensive
Question Practice Test with Answers &
Rationales| Free Pdf Access
1. A database is best defined as:
A. A collection of unrelated files
B. An organized collection of data
C. A spreadsheet only
D. A computer network
Correct Answer: B
Rationale: A database is a structured collection of related data that can be efficiently
accessed, managed, and updated.
2. A Database Management System (DBMS) is software used to:
A. Create, manage, and retrieve data
B. Design websites only
C. Build computer hardware
D. Manage operating systems only
Correct Answer: A
Rationale: A DBMS provides tools for storing, organizing, and accessing data.
3. Which of the following is an example of a DBMS?
A. Microsoft Access
B. Oracle Database
C. MySQL
D. All of the above
,Correct Answer: D
Rationale: All listed products are widely used database management systems.
4. Data refers to:
A. Processed information only
B. Raw facts and figures
C. Computer programs
D. Hardware components
Correct Answer: B
Rationale: Data consists of unprocessed facts that can be organized into meaningful
information.
5. Information is:
A. Raw data only
B. Data that has been processed into a meaningful form
C. Database software
D. A storage device
Correct Answer: B
Rationale: Information results when data is organized and interpreted.
6. In a relational database, data is stored in:
A. Folders
B. Tables
C. Programs
D. Operating systems
Correct Answer: B
Rationale: Relational databases organize information into tables consisting of rows and
columns.
7. A row in a database table is also called a:
, A. Field
B. Attribute
C. Record
D. Query
Correct Answer: C
Rationale: A record contains all data related to a specific entity instance.
8. A column in a database table is also called a:
A. Record
B. Field
C. Query
D. Report
Correct Answer: B
Rationale: A field stores a specific type of information for each record.
9. Which field uniquely identifies each record in a table?
A. Foreign Key
B. Candidate Key
C. Primary Key
D. Composite Key
Correct Answer: C
Rationale: A primary key ensures each record can be uniquely identified.
10. A foreign key is used to:
A. Delete records automatically
B. Establish relationships between tables
C. Store duplicate records
D. Encrypt data
Correct Answer: B
Rationale: Foreign keys link records across related tables.
Essentials Final Exam Practice
Examination 2026–2027 | Comprehensive
Question Practice Test with Answers &
Rationales| Free Pdf Access
1. A database is best defined as:
A. A collection of unrelated files
B. An organized collection of data
C. A spreadsheet only
D. A computer network
Correct Answer: B
Rationale: A database is a structured collection of related data that can be efficiently
accessed, managed, and updated.
2. A Database Management System (DBMS) is software used to:
A. Create, manage, and retrieve data
B. Design websites only
C. Build computer hardware
D. Manage operating systems only
Correct Answer: A
Rationale: A DBMS provides tools for storing, organizing, and accessing data.
3. Which of the following is an example of a DBMS?
A. Microsoft Access
B. Oracle Database
C. MySQL
D. All of the above
,Correct Answer: D
Rationale: All listed products are widely used database management systems.
4. Data refers to:
A. Processed information only
B. Raw facts and figures
C. Computer programs
D. Hardware components
Correct Answer: B
Rationale: Data consists of unprocessed facts that can be organized into meaningful
information.
5. Information is:
A. Raw data only
B. Data that has been processed into a meaningful form
C. Database software
D. A storage device
Correct Answer: B
Rationale: Information results when data is organized and interpreted.
6. In a relational database, data is stored in:
A. Folders
B. Tables
C. Programs
D. Operating systems
Correct Answer: B
Rationale: Relational databases organize information into tables consisting of rows and
columns.
7. A row in a database table is also called a:
, A. Field
B. Attribute
C. Record
D. Query
Correct Answer: C
Rationale: A record contains all data related to a specific entity instance.
8. A column in a database table is also called a:
A. Record
B. Field
C. Query
D. Report
Correct Answer: B
Rationale: A field stores a specific type of information for each record.
9. Which field uniquely identifies each record in a table?
A. Foreign Key
B. Candidate Key
C. Primary Key
D. Composite Key
Correct Answer: C
Rationale: A primary key ensures each record can be uniquely identified.
10. A foreign key is used to:
A. Delete records automatically
B. Establish relationships between tables
C. Store duplicate records
D. Encrypt data
Correct Answer: B
Rationale: Foreign keys link records across related tables.
