WGU D427 Data-Management & Applications Updated Questions And Answers With 100% Correct Answers Graded A+

WGU D427 Data-Management &
Applications Updated
Questions And Answers With 100%
Correct Answers Graded A+
QUESTIONS AND ANSWERS



QUESTIONS ANSWERS
San Francisco, CA 94110 USA
How many attributes are present in the -1
address fragment?
-2 -3
-4 4
The Package table has the following Weight—decimal
columns:
Description—optional variable length LastChangedDate—date
string
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 How would a database engine process an
update that violates a RESTRICT
referential integrity constraint?

,- The offending value would be set to the - The update would be rejected by the
database default. database.
- The offending value would be changed - The updated value would flow to the
to NULL. primary key.
The update would be rejected by the Which restriction applies when using a
database. materialized view?
- The users of the view must provide - The underlying data must be
search terms. periodically refreshed.
- The tables referenced in the view must - The rows in the table must be
be indexed. compressed.
The underlying data must be periodically Which query illustrates performing an
refreshed. outer join of the Movie table with a
different table?
- SELECT M.Title, A.Actor FROM WHERE M.ActorID = A.ID
Movie M, Actor A
- SELECT M.Title, A.Actor FROM LEFT JOIN Movie MB ON M.ID, Actor
Movie M A
- SELECT M.Title, A.Actor FROM RIGHT JOIN Actor A ON M.ActorID =
Movie M A.Id
- SELECT M.Title, A.Actor FROM INNER JOIN Actor A ON M.ActorID =
Movie M A.ID
SELECT M.Title, A.Actor FROM Movie Assume there are two tables, A and B.
M
LEFT JOIN Movie MB ON M.ID Actor
A
Which rows will always be included in - Only rows in Tables A and B that share
the result set if Table A is inner joined the join condition
with Table B?
- all rows in Table B - All rows in Table A
- Only rows in Tables A and B that do Only rows in Table A and B that share the
not share the join condition join condition
1. Portland, OR 97212 3
How many attributes are present in the
address fragment?

-1
-2
-3
-4

, 2. The Patient table has the following patient_id
columns:

first_name varchar(20)
last_name varchar (30)
birthdate date
patient_id int

Which column should be designated as
the primary key for the Patient table?

- first_name
- last_name
- birthdate
- patient_id
3. The Exam table has the following patient_id
columns:
exam_id int
exam_date date
exam_reason varchar(100)
patient_number int

Which column should be designated as
the foreign key for the Exam table?

- exam_id
- exam_date
- exam_reason
- patient_id
4. Which data type represents numbers decimal
with fractional values:

- varchar
- integer
- binary
- decimal
5. Which of the following is a DDL (Data CREATE INDEX
Definition Language) command?
CREATE, ALTER, DROP
- INSERT
- SELECT
- CREATE INDEX
- UPDATE
6. Which of the following is a DML (Data INSERT
Manipulation Language) command?