WGU - D427 - Data Management -
Applications – PreAssessment Exam
Prep 2025 Questions and Answers
100% Pass
San Francisco, CA 94110
USA
How many attributes are present in the address fragment?
-1
-2
-3
- 4 - ✔✔4
The Package table has the following columns:
Weight—decimal
Description—optional variable length string
COPYRIGHT © 2025 BY OLIVIA WEST, ALL RIGHTS RESERVED 1
,LastChangedDate—date
TrackingNumber—integer
Which column should be designated the primary key for the Package table?
- Weight
- Description
- LastChangedDate
- TrackingNumber - ✔✔Tracking Number
Which data type will store "2022-01-10 14:22:12" as a temporal value without loss of
information?
- DATE
- DATETIME
- DECIMAL
- BIGINT - ✔✔DATETIME
Which SQL command is an example of data definition language (DDL)?
- UPDATE
- ALTER
- SELECT
- DELETE - ✔✔CREATE, ALTER, OR DROP
COPYRIGHT © 2025 BY OLIVIA WEST, ALL RIGHTS RESERVED 2
,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.
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.
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
COPYRIGHT © 2025 BY OLIVIA WEST, ALL RIGHTS RESERVED 3
, 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
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
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?
- Only rows in Tables A and B that share the join condition
- all rows in Table B
- All rows in Table A
- Only rows in Tables A and B that do not share the join condition - ✔✔Only rows in
Table A and B that share the join condition
1. Portland, OR 97212
How many attributes are present in the address fragment?
COPYRIGHT © 2025 BY OLIVIA WEST, ALL RIGHTS RESERVED 4
Applications – PreAssessment Exam
Prep 2025 Questions and Answers
100% Pass
San Francisco, CA 94110
USA
How many attributes are present in the address fragment?
-1
-2
-3
- 4 - ✔✔4
The Package table has the following columns:
Weight—decimal
Description—optional variable length string
COPYRIGHT © 2025 BY OLIVIA WEST, ALL RIGHTS RESERVED 1
,LastChangedDate—date
TrackingNumber—integer
Which column should be designated the primary key for the Package table?
- Weight
- Description
- LastChangedDate
- TrackingNumber - ✔✔Tracking Number
Which data type will store "2022-01-10 14:22:12" as a temporal value without loss of
information?
- DATE
- DATETIME
- DECIMAL
- BIGINT - ✔✔DATETIME
Which SQL command is an example of data definition language (DDL)?
- UPDATE
- ALTER
- SELECT
- DELETE - ✔✔CREATE, ALTER, OR DROP
COPYRIGHT © 2025 BY OLIVIA WEST, ALL RIGHTS RESERVED 2
,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.
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.
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
COPYRIGHT © 2025 BY OLIVIA WEST, ALL RIGHTS RESERVED 3
, 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
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
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?
- Only rows in Tables A and B that share the join condition
- all rows in Table B
- All rows in Table A
- Only rows in Tables A and B that do not share the join condition - ✔✔Only rows in
Table A and B that share the join condition
1. Portland, OR 97212
How many attributes are present in the address fragment?
COPYRIGHT © 2025 BY OLIVIA WEST, ALL RIGHTS RESERVED 4
