WGU D427 Data Management Applications Pre Assessment Exam 140 Questions with Verified Answers,100%CORRECT

WGU D427 Data Management Applications Pre
Assessment Exam 140 Questions with Verified
Answers


4 - CORRECT ANSWER San Francisco, CA 94110
USA
How many attributes are present in the address fragment?


-1
-2
-3
-4


Tracking Number - CORRECT ANSWER 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


DATETIME - CORRECT ANSWER Which data type will store "2022-01-10 14:22:12"
as a temporal value without loss of information?


- DATE
- DATETIME
- DECIMAL
- BIGINT


CREATE, ALTER, OR DROP - CORRECT ANSWER Which SQL command is an example
of data definition language (DDL)?


- UPDATE
- ALTER
- SELECT
- DELETE


The update would be rejected by the database. - CORRECT ANSWER 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 underlying data must be periodically refreshed. - CORRECT ANSWER 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.


SELECT M.Title, A.Actor FROM Movie M
LEFT JOIN Movie MB ON M.ID Actor A - CORRECT ANSWER 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
INNER JOIN Actor A ON M.ActorID = A.ID


Only rows in Table A and B that share the join condition - CORRECT ANSWER
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


3 - CORRECT ANSWER 1. Portland, OR 97212
How many attributes are present in the address fragment?


-1
-2
-3
-4


patient_id - CORRECT ANSWER 2. The Patient table has the following columns:


first_name varchar(20)