WGU C175 / D426 Data Management
Foundations OA Exam Preparation
Newest Version with Complete
Questions and Correct Detailed
Answers| Brand New Version!
1. A database is primarily used to:
A. Store and organize data
B. Design websites
C. Compile programs
D. Encrypt emails
Answer: A
Rationale: A database is a structured system for storing and managing data.
2. What does DBMS stand for?
A. Data Backup Management System
B. Database Management System
C. Digital Business Management Service
D. Data Build Modeling System
Answer: B
Rationale: DBMS is software used to create and manage databases.
3. A primary key is used to:
A. Encrypt data
B. Uniquely identify a record
C. Sort data alphabetically only
D. Store duplicate values
Answer: B
Rationale: Primary keys uniquely identify each row in a table.
,4. A foreign key is used to:
A. Delete tables
B. Link two tables together
C. Encrypt data
D. Create indexes only
Answer: B
Rationale: Foreign keys establish relationships between tables.
5. A relational database organizes data into:
A. Files and folders
B. Tables
C. Images
D. Programs
Answer: B
Rationale: Relational databases use tables with rows and columns.
6. A row in a database table is also called a:
A. Field
B. Record
C. Attribute
D. Key
Answer: B
Rationale: A row represents a complete record.
7. A column in a database table is also called a:
A. Record
B. Attribute
C. File
D. Query
Answer: B
Rationale: Columns define attributes of data.
8. SQL stands for:
A. Structured Query Language
B. Simple Query Logic
,C. Sequential Question Language
D. System Quality Layer
Answer: A
Rationale: SQL is used to query and manage databases.
9. The SELECT statement is used to:
A. Delete data
B. Retrieve data
C. Insert tables
D. Encrypt data
Answer: B
Rationale: SELECT retrieves data from tables.
10. The INSERT statement is used to:
A. Add new data
B. Delete data
C. Encrypt data
D. Sort tables
Answer: A
Rationale: INSERT adds new records to a table.
11. The UPDATE statement is used to:
A. Modify existing data
B. Delete tables
C. Create databases
D. Backup data
Answer: A
Rationale: UPDATE changes existing records.
12. The DELETE statement is used to:
A. Remove data
B. Encrypt data
C. Create tables
D. Sort data
, Answer: A
Rationale: DELETE removes records from a table.
13. A database schema defines:
A. Hardware configuration
B. Structure of the database
C. Internet speed
D. File encryption
Answer: B
Rationale: A schema defines tables, fields, and relationships.
14. Normalization is used to:
A. Increase redundancy
B. Reduce data redundancy
C. Encrypt data
D. Delete databases
Answer: B
Rationale: Normalization organizes data efficiently.
15. The first normal form (1NF) requires:
A. Duplicate rows
B. Atomic values
C. No tables
D. No keys
Answer: B
Rationale: 1NF requires indivisible (atomic) values.
16. The purpose of a database index is to:
A. Slow queries
B. Speed up data retrieval
C. Delete records
D. Encrypt tables
Answer: B
Rationale: Indexes improve query performance.
Foundations OA Exam Preparation
Newest Version with Complete
Questions and Correct Detailed
Answers| Brand New Version!
1. A database is primarily used to:
A. Store and organize data
B. Design websites
C. Compile programs
D. Encrypt emails
Answer: A
Rationale: A database is a structured system for storing and managing data.
2. What does DBMS stand for?
A. Data Backup Management System
B. Database Management System
C. Digital Business Management Service
D. Data Build Modeling System
Answer: B
Rationale: DBMS is software used to create and manage databases.
3. A primary key is used to:
A. Encrypt data
B. Uniquely identify a record
C. Sort data alphabetically only
D. Store duplicate values
Answer: B
Rationale: Primary keys uniquely identify each row in a table.
,4. A foreign key is used to:
A. Delete tables
B. Link two tables together
C. Encrypt data
D. Create indexes only
Answer: B
Rationale: Foreign keys establish relationships between tables.
5. A relational database organizes data into:
A. Files and folders
B. Tables
C. Images
D. Programs
Answer: B
Rationale: Relational databases use tables with rows and columns.
6. A row in a database table is also called a:
A. Field
B. Record
C. Attribute
D. Key
Answer: B
Rationale: A row represents a complete record.
7. A column in a database table is also called a:
A. Record
B. Attribute
C. File
D. Query
Answer: B
Rationale: Columns define attributes of data.
8. SQL stands for:
A. Structured Query Language
B. Simple Query Logic
,C. Sequential Question Language
D. System Quality Layer
Answer: A
Rationale: SQL is used to query and manage databases.
9. The SELECT statement is used to:
A. Delete data
B. Retrieve data
C. Insert tables
D. Encrypt data
Answer: B
Rationale: SELECT retrieves data from tables.
10. The INSERT statement is used to:
A. Add new data
B. Delete data
C. Encrypt data
D. Sort tables
Answer: A
Rationale: INSERT adds new records to a table.
11. The UPDATE statement is used to:
A. Modify existing data
B. Delete tables
C. Create databases
D. Backup data
Answer: A
Rationale: UPDATE changes existing records.
12. The DELETE statement is used to:
A. Remove data
B. Encrypt data
C. Create tables
D. Sort data
, Answer: A
Rationale: DELETE removes records from a table.
13. A database schema defines:
A. Hardware configuration
B. Structure of the database
C. Internet speed
D. File encryption
Answer: B
Rationale: A schema defines tables, fields, and relationships.
14. Normalization is used to:
A. Increase redundancy
B. Reduce data redundancy
C. Encrypt data
D. Delete databases
Answer: B
Rationale: Normalization organizes data efficiently.
15. The first normal form (1NF) requires:
A. Duplicate rows
B. Atomic values
C. No tables
D. No keys
Answer: B
Rationale: 1NF requires indivisible (atomic) values.
16. The purpose of a database index is to:
A. Slow queries
B. Speed up data retrieval
C. Delete records
D. Encrypt tables
Answer: B
Rationale: Indexes improve query performance.
