Wgu D427 Data Management Applications Oa And Pre-Assessment Test Questions And Correct Answers (Verified Answers) Plus Rationales 2026 Q&A | Instant Download Pdf

Wgu D427 Data Management
Applications Oa And Pre-Assessment
Test Questions And Correct Answers
(Verified Answers) Plus Rationales
2026 Q&A | Instant Download Pdf
1. Which statement best describes the primary purpose of a relational
database management system (RDBMS)?
A. To store files without any defined relationships
B. To create only graphical user interfaces
C. To manage structured data stored in related tables
D. To replace all programming languages
Answer: C. To manage structured data stored in related tables
Rationale: A relational database management system organizes
structured information into tables and provides mechanisms for
creating relationships among those tables. It also supports querying,
inserting, updating, deleting, securing, and managing data.
2. Which SQL statement is used to retrieve data from a table?
A. SELECT
B. UPDATE
C. INSERT
D. DELETE
Answer: A. SELECT

,Rationale: SELECT retrieves data from one or more tables. UPDATE
changes existing rows, INSERT adds rows, and DELETE removes
rows.
3. A table contains StudentID, StudentName, and ProgramID. Which
field is most likely to serve as the primary key for identifying each
student uniquely?
A. StudentName
B. ProgramID
C. StudentID
D. ProgramName
Answer: C. StudentID
Rationale: A primary key uniquely identifies each row in a table.
StudentID is designed to identify an individual student, whereas
ProgramID may be shared by many students.
4. Which characteristic is required of a primary key?
A. It must contain duplicate values
B. It must uniquely identify each row
C. It must always contain text
D. It must reference another table
Answer: B. It must uniquely identify each row
Rationale: The defining characteristic of a primary key is uniqueness.
A primary-key value cannot identify two different rows, and primary-
key columns normally cannot contain NULL values.
5. Which SQL clause is used to restrict the rows returned by a
SELECT statement?

,A. ORDER BY
B. GROUP BY
C. HAVING
D. WHERE
Answer: D. WHERE
Rationale: WHERE filters individual rows according to a condition.
HAVING filters groups after aggregation, while ORDER BY sorts the
resulting rows.
6. What does the following query return?
SELECT FirstName, LastName
FROM Employee;
A. Every column from Employee
B. The first and last names from Employee
C. Only employees with non-null last names
D. The number of employees
Answer: B. The first and last names from Employee
Rationale: The SELECT list explicitly requests FirstName and
LastName. Unless another condition is specified, all rows from
Employee are eligible to appear.
7. Which operator is commonly used with a wildcard to search for
text beginning with a particular sequence?
A. LIKE
B. BETWEEN
C. IN
D. EXISTS
Answer: A. LIKE

, Rationale: LIKE performs pattern matching. For example, WHERE
LastName LIKE 'Sm%' can return names beginning with “Sm.”
8. What does the percent sign (%) represent in a SQL LIKE pattern?
A. Exactly one character
B. A numeric value
C. Zero or more characters
D. A NULL value
Answer: C. Zero or more characters
Rationale: In standard SQL pattern matching, % represents zero or
more characters. The underscore (_) generally represents exactly one
character.
9. Which query correctly returns employees whose salary is greater
than 50,000?
A. SELECT * FROM Employee WHERE Salary > 50000;
B. SELECT * FROM Employee HAVING Salary > 50000;
C. SELECT * FROM Employee WHEN Salary > 50000;
D. SELECT * FROM Employee GROUP Salary > 50000;
Answer: A. SELECT * FROM Employee WHERE Salary > 50000;
Rationale: WHERE is used to filter rows based on a condition. The
greater-than operator selects salaries exceeding 50,000.
10. Which SQL keyword is used to sort query results?
A. SORT
B. ORDER BY
C. ARRANGE
D. SEQUENCE
Answer: B. ORDER BY