1 | Page
WGU D427 DATA MANAGEMENT APPLICATIONS OA
PRE-ASSESSMENT EXAM 2026 |ALL QUESTIONS AND
CORRECT DETAILED ANSWERS | RATED A+ | NEW
AND REVISED
1. San Francisco, CA
94110 USA
How many attributes are present in the address fragment?
-1
-2
-3
- 4: 4
2. The Package table has the following
columns: Weight—decimal
Description—optional variable length
string LastChangedDate—date
TrackingNumber—integer
Which column should be designated the primary key for the Package table?
- Weight
- Description
- LastChangedDate
- TrackingNumber: Tracking Number
3. Which data type will store "2022-01-10 14:22:12" as a temporal value
without loss of information?
,2 | Page
- DATE
- DATETIME
- DECIMAL
- BIGINT: DATETIME
4. Which SQL command is an example of data definition language (DDL)?
- UPDATE
- ALTER
- SELECT
- DELETE: CREATE, ALTER, OR DROP
,3 | Page
5. How would a database engine process an update that violates a
RESTRICT referential integrity constraint?
- The offending value would be set to the database default.
- The update would be rejected by the database.
- The offending value would be changed to NULL.
- The updated value would flow to the primary key.: The update would be rejected by the
database.
6. Which restriction applies when using a materialized view?
- The users of the view must provide search terms.
- The underlying data must be periodically refreshed.
- The tables referenced in the view must be indexed.
- The rows in the table must be compressed.: The underlying data must be periodically refreshed.
7. Which query illustrates performing an outer join of the Movie table
with a different table?
- SELECT M.Title, A.Actor FROM Movie M,
Actor A WHERE M.ActorID = A.ID
- SELECT M.Title, A.Actor FROM
Movie M LEFT JOIN Movie MB ON
M.ID, Actor A
- SELECT M.Title, A.Actor FROM
Movie M RIGHT JOIN Actor A ON
M.ActorID = A.Id
- SELECT M.Title, A.Actor FROM Movie M
,4 | Page
INNER JOIN Actor A ON M.ActorID = A.ID: SELECT M.Title, A.Actor
FROM Movie M LEFT JOIN Movie MB ON M.ID Actor A
8. Assume there are two tables, A and B.
Which rows will always be included in the result set if Table A is inner
joined with Table B?
WGU D427 DATA MANAGEMENT APPLICATIONS OA
PRE-ASSESSMENT EXAM 2026 |ALL QUESTIONS AND
CORRECT DETAILED ANSWERS | RATED A+ | NEW
AND REVISED
1. San Francisco, CA
94110 USA
How many attributes are present in the address fragment?
-1
-2
-3
- 4: 4
2. The Package table has the following
columns: Weight—decimal
Description—optional variable length
string LastChangedDate—date
TrackingNumber—integer
Which column should be designated the primary key for the Package table?
- Weight
- Description
- LastChangedDate
- TrackingNumber: Tracking Number
3. Which data type will store "2022-01-10 14:22:12" as a temporal value
without loss of information?
,2 | Page
- DATE
- DATETIME
- DECIMAL
- BIGINT: DATETIME
4. Which SQL command is an example of data definition language (DDL)?
- UPDATE
- ALTER
- SELECT
- DELETE: CREATE, ALTER, OR DROP
,3 | Page
5. How would a database engine process an update that violates a
RESTRICT referential integrity constraint?
- The offending value would be set to the database default.
- The update would be rejected by the database.
- The offending value would be changed to NULL.
- The updated value would flow to the primary key.: The update would be rejected by the
database.
6. Which restriction applies when using a materialized view?
- The users of the view must provide search terms.
- The underlying data must be periodically refreshed.
- The tables referenced in the view must be indexed.
- The rows in the table must be compressed.: The underlying data must be periodically refreshed.
7. Which query illustrates performing an outer join of the Movie table
with a different table?
- SELECT M.Title, A.Actor FROM Movie M,
Actor A WHERE M.ActorID = A.ID
- SELECT M.Title, A.Actor FROM
Movie M LEFT JOIN Movie MB ON
M.ID, Actor A
- SELECT M.Title, A.Actor FROM
Movie M RIGHT JOIN Actor A ON
M.ActorID = A.Id
- SELECT M.Title, A.Actor FROM Movie M
,4 | Page
INNER JOIN Actor A ON M.ActorID = A.ID: SELECT M.Title, A.Actor
FROM Movie M LEFT JOIN Movie MB ON M.ID Actor A
8. Assume there are two tables, A and B.
Which rows will always be included in the result set if Table A is inner
joined with Table B?
