WGU D426 NEW PRE-ASSESSMENT – DATA MANAGEMENT FOUNDATIONS 2026/2027 |
EXAM-STYLE PRACTICE QUESTIONS | HIGH-YIELD CONCEPTS | CORRECT ANSWERS | DETAILED EXPLANATIONS |
LATEST UPDATE
1. If a company is transitioning from a relational database to a NoSQL database
to manage its data, what primary advantage should they expect?
Improved scalability for handling large datasets
Increased complexity in data management
Reduced performance for transaction processing
Mandatory use of SQL for data queries
2. Which of the following best describes a purpose of a Database Management
System?
It is designed to manage the retrieval of information from the
database.
It describes the data fields in each database record, such as field
description and length.
It defines the parent/child relationships in a lattice structure.
It is responsible for implementation, repair, and growth of a firm's
database.
3. What is the definition of referential integrity in the context of databases?
Referential integrity allows duplicate entries in a table.
Referential integrity ensures that relationships between tables
remain consistent.
Referential integrity is the method of storing data in a single table.
Referential integrity is the process of indexing data for faster retrieval.
,4. What is the name of the join that returns only matching rows from both
tables?
INNER JOIN
LEFT JOIN
FULL JOIN
RIGHT JOIN
5. If you attempt to join two tables on columns with incompatible data types,
what will be the likely outcome?
The join will automatically convert data types.
The join will succeed and return all records.
The join will succeed but return no results.
An error will occur during the join operation.
6. What is the difference between WHERE and HAVING?
HAVING is used to specify the conditions for joining tables
WHERE is used to filter data from the selected table, having is used to
filter data from a joined table
They are the same
WHERE filters data prior to aggregation, HAVING filters data after
aggregation
7. In a nonclustered index on a heap table, what is stored in the leaf level of the
index?
The data for the column the nonclustered index was created on
It is impossible to create a nonclustered index on an heap table
, The data for all the columns in the table
The clustered index key
The primary key
8. What is the purpose of an aggregate function in SQL?
To join multiple tables into a single result.
To create new tables from existing data.
To combine values from a set of rows in its calculations.
To filter rows based on specific criteria.
9. Describe how the SUM function can be utilized in a SQL query.
The SUM function is used to count the number of entries in a database
table.
The SUM function can be used in a SQL query to aggregate numeric
data from a specified column, providing the total value for that
column.
The SUM function retrieves unique values from a specified column.
The SUM function is used to sort data in ascending order.
10. What is the relationship between the columns appearing in a SELECT clause
and columns in a GROUP BY clause?
The SELECT clause may have additional non aggregate columns not
appearing in the GROUP BY clause. lse
The non aggregate columns in the SELECT clause must match the
columns in the GROUP BY clause.
, j The GROUP BY clause may have additional columns not in the SELECT
2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
clause.
j2
j 2 SELECT and GROUP BY clauses are independent so no relationship.
j2 j2 j2 j2 j2 j2 j2 j2 j2
11. The function CURDATE() returns...
j 2 j 2 j 2
j 2 All the above j2 j2
j 2 Can be included in a SELECT statement
j2 j2 j2 j2 j2 j2
j 2 Returns the current date j2 j2 j2
j 2 Is a function call
j2 j2 j2
12. Describe how the CASCADE constraint affects the integrity of a database
j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
when a primary key is updated.
j2 j2 j2 j2 j2 j2
j The CASCADE constraint prevents any updates to foreign keys when a
2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
primarykeyischanged.
j2 j2 j2 j2
j2 The CASCADE constraint ensures that any updates to a primary key are
j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
automatically reflected in the corresponding foreign keys,
j2 j2 j2 j2 j2 j2 j2
maintaining referential integrity.
j2 j2 j2
j The CASCADE constraint allows foreign keys to be set to null when a
2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
j2 primarykeyismodified. j2 j2 j2
j The CASCADE constraint requires manual updates to foreign keys after
2 j2 j2 j2 j2 j2 j2 j2 j2 j2
aprimarykeychange.
j2 j2 j2 j2
13. If you want to create a query that retrieves employee names from a table
j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
called 'Employees' and temporarily rename the output column to
j2 j2 j2 j2 j2 j2 j2 j2 j2
'EmployeeName', which SQL syntax would you use?
j2 j2 j2 j2 j2 j2 j2
j 2 SELECT name FROM Employees; j2 j2 j2
j 2 SELECT name FROM Employees AS EmployeeName; j2 j2 j2 j2 j2
EXAM-STYLE PRACTICE QUESTIONS | HIGH-YIELD CONCEPTS | CORRECT ANSWERS | DETAILED EXPLANATIONS |
LATEST UPDATE
1. If a company is transitioning from a relational database to a NoSQL database
to manage its data, what primary advantage should they expect?
Improved scalability for handling large datasets
Increased complexity in data management
Reduced performance for transaction processing
Mandatory use of SQL for data queries
2. Which of the following best describes a purpose of a Database Management
System?
It is designed to manage the retrieval of information from the
database.
It describes the data fields in each database record, such as field
description and length.
It defines the parent/child relationships in a lattice structure.
It is responsible for implementation, repair, and growth of a firm's
database.
3. What is the definition of referential integrity in the context of databases?
Referential integrity allows duplicate entries in a table.
Referential integrity ensures that relationships between tables
remain consistent.
Referential integrity is the method of storing data in a single table.
Referential integrity is the process of indexing data for faster retrieval.
,4. What is the name of the join that returns only matching rows from both
tables?
INNER JOIN
LEFT JOIN
FULL JOIN
RIGHT JOIN
5. If you attempt to join two tables on columns with incompatible data types,
what will be the likely outcome?
The join will automatically convert data types.
The join will succeed and return all records.
The join will succeed but return no results.
An error will occur during the join operation.
6. What is the difference between WHERE and HAVING?
HAVING is used to specify the conditions for joining tables
WHERE is used to filter data from the selected table, having is used to
filter data from a joined table
They are the same
WHERE filters data prior to aggregation, HAVING filters data after
aggregation
7. In a nonclustered index on a heap table, what is stored in the leaf level of the
index?
The data for the column the nonclustered index was created on
It is impossible to create a nonclustered index on an heap table
, The data for all the columns in the table
The clustered index key
The primary key
8. What is the purpose of an aggregate function in SQL?
To join multiple tables into a single result.
To create new tables from existing data.
To combine values from a set of rows in its calculations.
To filter rows based on specific criteria.
9. Describe how the SUM function can be utilized in a SQL query.
The SUM function is used to count the number of entries in a database
table.
The SUM function can be used in a SQL query to aggregate numeric
data from a specified column, providing the total value for that
column.
The SUM function retrieves unique values from a specified column.
The SUM function is used to sort data in ascending order.
10. What is the relationship between the columns appearing in a SELECT clause
and columns in a GROUP BY clause?
The SELECT clause may have additional non aggregate columns not
appearing in the GROUP BY clause. lse
The non aggregate columns in the SELECT clause must match the
columns in the GROUP BY clause.
, j The GROUP BY clause may have additional columns not in the SELECT
2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
clause.
j2
j 2 SELECT and GROUP BY clauses are independent so no relationship.
j2 j2 j2 j2 j2 j2 j2 j2 j2
11. The function CURDATE() returns...
j 2 j 2 j 2
j 2 All the above j2 j2
j 2 Can be included in a SELECT statement
j2 j2 j2 j2 j2 j2
j 2 Returns the current date j2 j2 j2
j 2 Is a function call
j2 j2 j2
12. Describe how the CASCADE constraint affects the integrity of a database
j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
when a primary key is updated.
j2 j2 j2 j2 j2 j2
j The CASCADE constraint prevents any updates to foreign keys when a
2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
primarykeyischanged.
j2 j2 j2 j2
j2 The CASCADE constraint ensures that any updates to a primary key are
j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
automatically reflected in the corresponding foreign keys,
j2 j2 j2 j2 j2 j2 j2
maintaining referential integrity.
j2 j2 j2
j The CASCADE constraint allows foreign keys to be set to null when a
2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
j2 primarykeyismodified. j2 j2 j2
j The CASCADE constraint requires manual updates to foreign keys after
2 j2 j2 j2 j2 j2 j2 j2 j2 j2
aprimarykeychange.
j2 j2 j2 j2
13. If you want to create a query that retrieves employee names from a table
j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2 j2
called 'Employees' and temporarily rename the output column to
j2 j2 j2 j2 j2 j2 j2 j2 j2
'EmployeeName', which SQL syntax would you use?
j2 j2 j2 j2 j2 j2 j2
j 2 SELECT name FROM Employees; j2 j2 j2
j 2 SELECT name FROM Employees AS EmployeeName; j2 j2 j2 j2 j2
