WGU D427 DATABASE
MANAGEMENT APPLICATI ONS
EXAM PREASSESSMENT AND
OBJECTIVE ASSESSMENT
ACCURATE AND VERIFIE D FOR
GUARANTEED PAS S LATEST
UPDATE
Question : How many attributes are present in the
address fragment?
1
2
3
4
Correct answer: 4
Question : 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
Correct answer: Tracking Number
Question : Which data type will store "2022-01-10
14:22:12" as a temporal value without loss of information?
DATE
DATETIME
DECIMAL
BIGINT
Correct answer: DATETIME
Question : Which SQL command is an example of data
definition language (DDL)?
UPDATE
ALTER
SELECT
DELETE
Correct answer: CREATE, ALTER, OR DROP
Question : 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.
Correct answer: The update would be rejected by the
database.
Question : 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.
Correct answer: The underlying data must be
periodically refreshed.
Question : 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