WGU C175 DataManagement Foundations
Exam 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 management system (DBMS)?
A) To perform data analytics
B) To store and manage data efficiently
C) To design web applications
D) To provide user authentication
B) To store and manage data efficiently
A DBMS provides a structured environment to store, retrieve, and manage data effectively.
2. Which type of database model organizes data into tables consisting of rows and
columns?
A) Hierarchical
B) Network
C) Relational
D) Object-oriented
C) Relational
Relational databases use tables with rows (records) and columns (attributes) to organize
data.
3. What does SQL stand for?
A) Structured Query Language
B) Simple Query Language
C) Standard Quality Language
D) Structured Quality Logic
A) Structured Query Language
SQL is the standard language for querying and manipulating relational databases.
4. Which SQL command is used to remove a table from a database?
A) DELETE TABLE
, B) DROP TABLE
C) REMOVE TABLE
D) TRUNCATE TABLE
B) DROP TABLE
DROP TABLE permanently deletes a table and its data from the database.
5. In relational databases, what is a primary key?
A) A field that can contain null values
B) A field used to uniquely identify a record
C) A field used to join two databases
D) A field that stores foreign references
B) A field used to uniquely identify a record
A primary key ensures each record in a table is unique and cannot be null.
6. What is the purpose of a foreign key?
A) To uniquely identify each record in a table
B) To link two tables together
C) To improve database performance
D) To store large objects
B) To link two tables together
A foreign key in one table refers to the primary key in another table to establish
relationships.
7. Which of the following is a characteristic of a normalized database?
A) Redundancy
B) Data consistency
C) Complex queries only
D) Denormalized tables
B) Data consistency
Normalization reduces redundancy and ensures data integrity, improving consistency.
8. What is the first normal form (1NF) in database normalization?
A) Eliminating duplicate tables
B) Removing repeating groups and ensuring atomic values
C) Establishing foreign key constraints
D) Splitting tables into multiple databases
B) Removing repeating groups and ensuring atomic values
1NF requires that each column contains atomic (indivisible) values and there are no
repeating groups.
, 9. Which SQL clause is used to filter the rows returned by a query?
A) ORDER BY
B) GROUP BY
C) WHERE
D) HAVING
C) WHERE
The WHERE clause specifies conditions that rows must meet to be included in the result
set.
10. What type of relationship exists when one record in a table can relate to many
records in another table?
A) One-to-one
B) One-to-many
C) Many-to-many
D) Self-referencing
B) One-to-many
A one-to-many relationship allows a single record in one table to be associated with
multiple records in another table.
11. Which SQL function returns the total number of rows in a table or query?
A) SUM()
B) COUNT()
C) AVG()
D) MAX()
B) COUNT()
COUNT() returns the number of rows that meet a specified condition.
12. What is the purpose of the GROUP BY clause in SQL?
A) To filter individual rows
B) To sort data alphabetically
C) To aggregate data by one or more columns
D) To join multiple tables
C) To aggregate data by one or more columns
GROUP BY organizes rows with the same values into summary rows for aggregate
functions like SUM, AVG, COUNT.
13. Which type of database is optimized for large-scale analytics and reporting?
A) OLTP (Online Transaction Processing)
B) OLAP (Online Analytical Processing)
C) NoSQL
D) Flat-file
Exam 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 management system (DBMS)?
A) To perform data analytics
B) To store and manage data efficiently
C) To design web applications
D) To provide user authentication
B) To store and manage data efficiently
A DBMS provides a structured environment to store, retrieve, and manage data effectively.
2. Which type of database model organizes data into tables consisting of rows and
columns?
A) Hierarchical
B) Network
C) Relational
D) Object-oriented
C) Relational
Relational databases use tables with rows (records) and columns (attributes) to organize
data.
3. What does SQL stand for?
A) Structured Query Language
B) Simple Query Language
C) Standard Quality Language
D) Structured Quality Logic
A) Structured Query Language
SQL is the standard language for querying and manipulating relational databases.
4. Which SQL command is used to remove a table from a database?
A) DELETE TABLE
, B) DROP TABLE
C) REMOVE TABLE
D) TRUNCATE TABLE
B) DROP TABLE
DROP TABLE permanently deletes a table and its data from the database.
5. In relational databases, what is a primary key?
A) A field that can contain null values
B) A field used to uniquely identify a record
C) A field used to join two databases
D) A field that stores foreign references
B) A field used to uniquely identify a record
A primary key ensures each record in a table is unique and cannot be null.
6. What is the purpose of a foreign key?
A) To uniquely identify each record in a table
B) To link two tables together
C) To improve database performance
D) To store large objects
B) To link two tables together
A foreign key in one table refers to the primary key in another table to establish
relationships.
7. Which of the following is a characteristic of a normalized database?
A) Redundancy
B) Data consistency
C) Complex queries only
D) Denormalized tables
B) Data consistency
Normalization reduces redundancy and ensures data integrity, improving consistency.
8. What is the first normal form (1NF) in database normalization?
A) Eliminating duplicate tables
B) Removing repeating groups and ensuring atomic values
C) Establishing foreign key constraints
D) Splitting tables into multiple databases
B) Removing repeating groups and ensuring atomic values
1NF requires that each column contains atomic (indivisible) values and there are no
repeating groups.
, 9. Which SQL clause is used to filter the rows returned by a query?
A) ORDER BY
B) GROUP BY
C) WHERE
D) HAVING
C) WHERE
The WHERE clause specifies conditions that rows must meet to be included in the result
set.
10. What type of relationship exists when one record in a table can relate to many
records in another table?
A) One-to-one
B) One-to-many
C) Many-to-many
D) Self-referencing
B) One-to-many
A one-to-many relationship allows a single record in one table to be associated with
multiple records in another table.
11. Which SQL function returns the total number of rows in a table or query?
A) SUM()
B) COUNT()
C) AVG()
D) MAX()
B) COUNT()
COUNT() returns the number of rows that meet a specified condition.
12. What is the purpose of the GROUP BY clause in SQL?
A) To filter individual rows
B) To sort data alphabetically
C) To aggregate data by one or more columns
D) To join multiple tables
C) To aggregate data by one or more columns
GROUP BY organizes rows with the same values into summary rows for aggregate
functions like SUM, AVG, COUNT.
13. Which type of database is optimized for large-scale analytics and reporting?
A) OLTP (Online Transaction Processing)
B) OLAP (Online Analytical Processing)
C) NoSQL
D) Flat-file
