WGUD449PSYCHIATRICANDMENTALHEALTH s s s s s
NURSINGPRACTICEEXAM2QUESTIONSAND
s s s s s s
CORRECTANSWERS(VERIFIEDANSWERS)
s s s s
PLUSRATIONALES2025 s s s
1. SanFrancisco,CA94110 s s s
USA
s
Howmany attributes are presentinthe address fragment?
s s s s s s s s
-1 s
-2 s
-3 s
- 4:ANS4s s
2. ThePackagetablehasthefollowingcolumns:
s s s s s s
Weight—decimal
s
Description—optionalvariablelengthstring s s s
LastChangedDate—date
s
TrackingNumber—integer
s
Whichcolumn shouldbe designated the primary key for the Package table?
s s s s s s s s s s s
- Weight
- Description
- LastChangedDate
1/21s s
,- TrackingNumber:ANSTracking Number s s s
3. Whichdatatypewillstore"2022-01-1014:22:12"asatemporalvaluewithoutloss
s s s s s s s s s s s s
of information?
s s
- DATE
- DATETIME
- DECIMAL
- BIGINT: ANSDATETIME s s
4. Which SQL command is an example of data definition language (DDL)?
s s s s s s s s s s
- UPDATE
- ALTER
- SELECT
- DELETE: ANSCREATE,ALTER,ORDROP
s s s s s
5. HowwouldadatabaseengineprocessanupdatethatviolatesaRESTRICT
s s s s s s s s s s s
referential integrity constraint?
s s s
- Theoffending value would be set to the database default.
s s s s s s s s s
- Theupdate would be rejected by the database.
s s s s s s s
- Theoffendingvalue would be changed to NULL.
s s s s s s s
2/21 s s
, - Theupdatedvaluewouldflowtotheprimarykey.:ANSTheupdatewouldberejectedby
s s s s s s s s s s s s s s s
the database.
s s
6. Which restriction applies when using a materialized view? s s s s s s s
- Theusersoftheviewmustprovidesearchterms.
s s s s s s s s
- Theunderlying datamust be periodically refreshed.
s s s s s s
- Thetables referencedin the view mustbe indexed.
s s s s s s s s
- Therowsinthetablemustbecompressed.:ANSTheunderlyingdatamustbe
s s s s s s s s s s s s s
periodically refreshed.
s s
7. WhichqueryillustratesperforminganouterjoinoftheMovietable witha s s s s s s s s s s s s
different table?
s s
- SELECTM.Title,A.ActorFROMMovieM,ActorA s s s s s s s
WHERE M.ActorID = A.ID
s s s s
- SELECTM.Title,A.ActorFROMMovieM s s s s s
LEFT JOIN Movie MB ON M.ID, Actor A
s s s s s s s s
- SELECT M.Title,A.Actor FROM Movie M s s s s s
RIGHTJOINActorAONM.ActorID=A.Id
s s s s s s s s
- SELECT M.Title,A.Actor FROM Movie M s s s s s
INNERJOINActorAONM.ActorID=A.ID:ANSSELECTM.Title,A.ActorFROMMovie
s s s s s s s s s s s s s
M
s
LEFT JOIN Movie MB ON M.ID Actor A s s s s s s s
8. Assume there are two tables,A and B. s s s s s s s
WhichrowswillalwaysbeincludedintheresultsetifTableAisinnerjoined with Table
s s s s s s s s s s s s s s s s s
B?
s
- OnlyrowsinTablesAandBthatsharethejoincondition s s s s s s s s s s s
- allrowsinTableB s s s s
- AllrowsinTableA s s s s
- OnlyrowsinTablesAandBthatdonotsharethejoincondition: ANSOnlyrows in
s s s s s s s s s s s s s s s s s
Table A and B that share the join condition
s s s s s s s s s
9. 1.Portland,OR 97212 s s s
Howmany attributes are presentinthe address fragment?
s s s s s s s s
-1 s
-2 s
3/21
s s
NURSINGPRACTICEEXAM2QUESTIONSAND
s s s s s s
CORRECTANSWERS(VERIFIEDANSWERS)
s s s s
PLUSRATIONALES2025 s s s
1. SanFrancisco,CA94110 s s s
USA
s
Howmany attributes are presentinthe address fragment?
s s s s s s s s
-1 s
-2 s
-3 s
- 4:ANS4s s
2. ThePackagetablehasthefollowingcolumns:
s s s s s s
Weight—decimal
s
Description—optionalvariablelengthstring s s s
LastChangedDate—date
s
TrackingNumber—integer
s
Whichcolumn shouldbe designated the primary key for the Package table?
s s s s s s s s s s s
- Weight
- Description
- LastChangedDate
1/21s s
,- TrackingNumber:ANSTracking Number s s s
3. Whichdatatypewillstore"2022-01-1014:22:12"asatemporalvaluewithoutloss
s s s s s s s s s s s s
of information?
s s
- DATE
- DATETIME
- DECIMAL
- BIGINT: ANSDATETIME s s
4. Which SQL command is an example of data definition language (DDL)?
s s s s s s s s s s
- UPDATE
- ALTER
- SELECT
- DELETE: ANSCREATE,ALTER,ORDROP
s s s s s
5. HowwouldadatabaseengineprocessanupdatethatviolatesaRESTRICT
s s s s s s s s s s s
referential integrity constraint?
s s s
- Theoffending value would be set to the database default.
s s s s s s s s s
- Theupdate would be rejected by the database.
s s s s s s s
- Theoffendingvalue would be changed to NULL.
s s s s s s s
2/21 s s
, - Theupdatedvaluewouldflowtotheprimarykey.:ANSTheupdatewouldberejectedby
s s s s s s s s s s s s s s s
the database.
s s
6. Which restriction applies when using a materialized view? s s s s s s s
- Theusersoftheviewmustprovidesearchterms.
s s s s s s s s
- Theunderlying datamust be periodically refreshed.
s s s s s s
- Thetables referencedin the view mustbe indexed.
s s s s s s s s
- Therowsinthetablemustbecompressed.:ANSTheunderlyingdatamustbe
s s s s s s s s s s s s s
periodically refreshed.
s s
7. WhichqueryillustratesperforminganouterjoinoftheMovietable witha s s s s s s s s s s s s
different table?
s s
- SELECTM.Title,A.ActorFROMMovieM,ActorA s s s s s s s
WHERE M.ActorID = A.ID
s s s s
- SELECTM.Title,A.ActorFROMMovieM s s s s s
LEFT JOIN Movie MB ON M.ID, Actor A
s s s s s s s s
- SELECT M.Title,A.Actor FROM Movie M s s s s s
RIGHTJOINActorAONM.ActorID=A.Id
s s s s s s s s
- SELECT M.Title,A.Actor FROM Movie M s s s s s
INNERJOINActorAONM.ActorID=A.ID:ANSSELECTM.Title,A.ActorFROMMovie
s s s s s s s s s s s s s
M
s
LEFT JOIN Movie MB ON M.ID Actor A s s s s s s s
8. Assume there are two tables,A and B. s s s s s s s
WhichrowswillalwaysbeincludedintheresultsetifTableAisinnerjoined with Table
s s s s s s s s s s s s s s s s s
B?
s
- OnlyrowsinTablesAandBthatsharethejoincondition s s s s s s s s s s s
- allrowsinTableB s s s s
- AllrowsinTableA s s s s
- OnlyrowsinTablesAandBthatdonotsharethejoincondition: ANSOnlyrows in
s s s s s s s s s s s s s s s s s
Table A and B that share the join condition
s s s s s s s s s
9. 1.Portland,OR 97212 s s s
Howmany attributes are presentinthe address fragment?
s s s s s s s s
-1 s
-2 s
3/21
s s
