WGU D449 Mental Health Interventions and Assessments – With All Answers (Complete Guide)

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