WhichcomponentdoestheSQLTuningAdvisorNOTanalyzefortheSQLstatements?()
ADDM
B. AWR
CursorCache
D. SQLTuningSets
E. FlashRecoveryArea
YouexecutethiscommandtodroptheITEMtable,whichhastheprimarykeyreferredintheORDERtable:SQL>DROPTABLEscott.itemCASCADECONSTRAINTSPURGE;Whichtwostatementsaretrueabouttheeffectofthecommand()
A. NoflashbackispossibletobringbacktheITEMtable.
B. TheORDERtableisdroppedalongwiththeITEMtable.
C. ThedependentreferentialintegrityconstraintsintheORDERtablearedisabled.
D. ThedependentreferentialintegrityconstraintsintheORDERtableareremoved.
E. ThetabledefinitionoftheITEMtableandassociatedindexesareplacedintherecyclebin.
WhichtwostatementsaretrueregardingtheUSINGandONclausesintablejoins?()
A. BothUSINGandONclausescanbeusedforequijoinsandnonequijoins
B. AmaximumofonepairofcolumnscanbejoinedbetweentwotablesusingtheONclause
C. TheONclausecanbeusedtojointablesoncolumnsthathavedifferentnamesbutcompatibledatatypes
D. TheWHEREclausecanbeusedtoapplyadditionalconditionsinSELECTstatementscontainingtheONortheUSINGclause
Inyourdatabaseinstance,theusersessionsareconnectedtothedatabaseserverfromtheremotemachines.Youwanttoachievethefollowingfortheseusers:1:Theuseraccountmustbelockedafterfourunsuccessfulloginattempts.PASSWORD_LOCK_TIME2:Theusermustbepromptedtochangethepasswordatregularintervals.PASSWORD_LIFE_TIME3:Theusermaynothavemorethanthreesimultaneoussessions.SESSIONS_PER_USER4:Theusersessionmustautomaticallybeloggedoffifmorethan10minuteselapsedtimeused.CONNECT_TIMEHowwouldyouaccomplishtheabove()
A. byassigningprofilesfortheusers
B. byimplementingFine-GrainedAuditing(FGA)
C. bygrantingasecureapplicationroletotheusers
D. byimplementingtheDatabaseResourceManagerplan