WGU - D427 - Data Management - Applications - PreAssessment
WGU - D427 - Data Management - Applications - PreAssessment
Study online at https://quizlet.com/_e3bgcr
1. San Francisco, CA 94110 4
USA
How many attributes are present in the address frag-
ment?
-1
-2
-3
-4
2. The Package table has the following columns: Tracking Number
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
3. Which data type will store "2022-01-10 14:22:12" as a DATETIME
temporal value without loss of information?
- DATE
- DATETIME
- DECIMAL
- BIGINT
4. Which SQL command is an example of data definition CREATE, ALTER, OR DROP
language (DDL)?
, WGU - D427 - Data Management - Applications - PreAssessment
WGU - D427 - Data Management - Applications - PreAssessment
Study online at https://quizlet.com/_e3bgcr
- UPDATE
- ALTER
- SELECT
- DELETE
5. How would a database engine process an update that The update would be re-
violates a RESTRICT referential integrity constraint? jected by the database.
- 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.
6. Which restriction applies when using a materialized The underlying data must
view? be periodically refreshed.
- 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.
7. Which query illustrates performing an outer join of the SELECT M.Title, A.Actor
Movie table with a different table? FROM Movie M
LEFT JOIN Movie MB ON
- SELECT M.Title, A.Actor FROM Movie M, Actor A M.ID 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
, WGU - D427 - Data Management - Applications - PreAssessment
WGU - D427 - Data Management - Applications - PreAssessment
Study online at https://quizlet.com/_e3bgcr
- SELECT M.Title, A.Actor FROM Movie M
INNER JOIN Actor A ON M.ActorID = A.ID
8. Assume there are two tables, A and B. Only rows in Table A and B
Which rows will always be included in the result set if that share the join condi-
Table A is inner joined with Table B? tion
- Only rows in Tables A and B that share the join condi-
tion
- all rows in Table B
- All rows in Table A
- Only rows in Tables A and B that do not share the join
condition
9. 1. Portland, OR 97212 3
How many attributes are present in the address frag-
ment?
-1
-2
-3
-4
10. 2. The Patient table has the following columns: patient_id
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?
WGU - D427 - Data Management - Applications - PreAssessment
Study online at https://quizlet.com/_e3bgcr
1. San Francisco, CA 94110 4
USA
How many attributes are present in the address frag-
ment?
-1
-2
-3
-4
2. The Package table has the following columns: Tracking Number
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
3. Which data type will store "2022-01-10 14:22:12" as a DATETIME
temporal value without loss of information?
- DATE
- DATETIME
- DECIMAL
- BIGINT
4. Which SQL command is an example of data definition CREATE, ALTER, OR DROP
language (DDL)?
, WGU - D427 - Data Management - Applications - PreAssessment
WGU - D427 - Data Management - Applications - PreAssessment
Study online at https://quizlet.com/_e3bgcr
- UPDATE
- ALTER
- SELECT
- DELETE
5. How would a database engine process an update that The update would be re-
violates a RESTRICT referential integrity constraint? jected by the database.
- 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.
6. Which restriction applies when using a materialized The underlying data must
view? be periodically refreshed.
- 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.
7. Which query illustrates performing an outer join of the SELECT M.Title, A.Actor
Movie table with a different table? FROM Movie M
LEFT JOIN Movie MB ON
- SELECT M.Title, A.Actor FROM Movie M, Actor A M.ID 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
, WGU - D427 - Data Management - Applications - PreAssessment
WGU - D427 - Data Management - Applications - PreAssessment
Study online at https://quizlet.com/_e3bgcr
- SELECT M.Title, A.Actor FROM Movie M
INNER JOIN Actor A ON M.ActorID = A.ID
8. Assume there are two tables, A and B. Only rows in Table A and B
Which rows will always be included in the result set if that share the join condi-
Table A is inner joined with Table B? tion
- Only rows in Tables A and B that share the join condi-
tion
- all rows in Table B
- All rows in Table A
- Only rows in Tables A and B that do not share the join
condition
9. 1. Portland, OR 97212 3
How many attributes are present in the address frag-
ment?
-1
-2
-3
-4
10. 2. The Patient table has the following columns: patient_id
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?
