WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA EXAM NEWEST
2025 With Actual Questions & Verified
Answers,Plus Rationales/Expert
Verified For Guaranteed Pass
2025/2026 /Latest Update/Instant
Download Pdf
1. What is the primary purpose of a database?
a. To store data permanently
b. To provide a mechanism for querying, creating, modifying, and deleting data
c. To perform complex calculations
d. To generate reports automatically
Answer: b. To provide a mechanism for querying, creating, modifying, and deleting data
Rationale: Databases are designed to manage and facilitate the CRUD operations (Create,
Read, Update, Delete) on data efficiently.
2. Which of the following is NOT a type of database model?
a. Relational
b. Hierarchical
c. Object-oriented
d. Linear
Answer: d. Linear
Rationale: Linear is not a recognized database model. Common models include relational,
hierarchical, and object-oriented.
3. In a relational database, what is a primary key?
,a. A field that uniquely identifies a record in a table
b. A field that links two tables together
c. A field that stores large data
d. A field that allows duplicate values
Answer: a. A field that uniquely identifies a record in a table
Rationale: A primary key ensures that each record within a table can be uniquely identified.
4. What does SQL stand for?
a. Simple Query Language
b. Structured Query Language
c. Sequential Query Language
d. Standard Query Language
Answer: b. Structured Query Language
Rationale: SQL is the standard language used for managing and manipulating relational
databases.
5. Which SQL statement is used to retrieve data from a database?
a. GET
b. SELECT
c. OPEN
d. FETCH
Answer: b. SELECT
Rationale: The SELECT statement is used to query and retrieve data from a database.
6. What is normalization in database design?
a. The process of removing duplicate data
b. The process of organizing data to reduce redundancy
c. The process of indexing data
d. The process of encrypting data
Answer: b. The process of organizing data to reduce redundancy
Rationale: Normalization involves structuring a database to minimize redundancy and
dependency.
, 7. Which normal form requires that a table is in 1NF and all non-key attributes are fully
functionally dependent on the primary key?
a. 1NF
b. 2NF
c. 3NF
d. BCNF
Answer: b. 2NF
Rationale: Second Normal Form (2NF) requires that a table is in 1NF and that all non-key
attributes are fully functionally dependent on the primary key.
8. What is a foreign key?
a. A key used to encrypt data
b. A key that uniquely identifies a record in a table
c. A key used to link two tables together
d. A key used to sort data
Answer: c. A key used to link two tables together
Rationale: A foreign key is a field in one table that uniquely identifies a row of another table.
9. Which of the following is an example of a DDL command?
a. SELECT
b. INSERT
c. CREATE
d. UPDATE
Answer: c. CREATE
Rationale: Data Definition Language (DDL) commands define and modify database
structures; CREATE is used to create new tables or databases.
10. Which of the following is a characteristic of a flat file database?
a. Stores data in a single table
b. Supports relationships between tables
c. Stores data in multiple tables
d. Uses complex queries
FOUNDATIONS OA EXAM NEWEST
2025 With Actual Questions & Verified
Answers,Plus Rationales/Expert
Verified For Guaranteed Pass
2025/2026 /Latest Update/Instant
Download Pdf
1. What is the primary purpose of a database?
a. To store data permanently
b. To provide a mechanism for querying, creating, modifying, and deleting data
c. To perform complex calculations
d. To generate reports automatically
Answer: b. To provide a mechanism for querying, creating, modifying, and deleting data
Rationale: Databases are designed to manage and facilitate the CRUD operations (Create,
Read, Update, Delete) on data efficiently.
2. Which of the following is NOT a type of database model?
a. Relational
b. Hierarchical
c. Object-oriented
d. Linear
Answer: d. Linear
Rationale: Linear is not a recognized database model. Common models include relational,
hierarchical, and object-oriented.
3. In a relational database, what is a primary key?
,a. A field that uniquely identifies a record in a table
b. A field that links two tables together
c. A field that stores large data
d. A field that allows duplicate values
Answer: a. A field that uniquely identifies a record in a table
Rationale: A primary key ensures that each record within a table can be uniquely identified.
4. What does SQL stand for?
a. Simple Query Language
b. Structured Query Language
c. Sequential Query Language
d. Standard Query Language
Answer: b. Structured Query Language
Rationale: SQL is the standard language used for managing and manipulating relational
databases.
5. Which SQL statement is used to retrieve data from a database?
a. GET
b. SELECT
c. OPEN
d. FETCH
Answer: b. SELECT
Rationale: The SELECT statement is used to query and retrieve data from a database.
6. What is normalization in database design?
a. The process of removing duplicate data
b. The process of organizing data to reduce redundancy
c. The process of indexing data
d. The process of encrypting data
Answer: b. The process of organizing data to reduce redundancy
Rationale: Normalization involves structuring a database to minimize redundancy and
dependency.
, 7. Which normal form requires that a table is in 1NF and all non-key attributes are fully
functionally dependent on the primary key?
a. 1NF
b. 2NF
c. 3NF
d. BCNF
Answer: b. 2NF
Rationale: Second Normal Form (2NF) requires that a table is in 1NF and that all non-key
attributes are fully functionally dependent on the primary key.
8. What is a foreign key?
a. A key used to encrypt data
b. A key that uniquely identifies a record in a table
c. A key used to link two tables together
d. A key used to sort data
Answer: c. A key used to link two tables together
Rationale: A foreign key is a field in one table that uniquely identifies a row of another table.
9. Which of the following is an example of a DDL command?
a. SELECT
b. INSERT
c. CREATE
d. UPDATE
Answer: c. CREATE
Rationale: Data Definition Language (DDL) commands define and modify database
structures; CREATE is used to create new tables or databases.
10. Which of the following is a characteristic of a flat file database?
a. Stores data in a single table
b. Supports relationships between tables
c. Stores data in multiple tables
d. Uses complex queries
