Which four are valid Oracle constraint types? ()
A. CASCADE
B. UNIQUE
C. NONUNIQUE
D. CHECK
E. PRIMARY KEY
F. CONSTANTG. NOT NULL
查看答案
Youhaveadiskgroup,DGROUP1,withthreedisksandNORMALredundancy.Youexecutethefollowingcommandtocreateatemplateforthediskgroup:ALTERDISKGROUPdgroup1ADDTEMPLATEmy_tempATTRIBUTES(MIRRORFINE);Whichstatementistrue?()
A. WhenafileiscreatedinDGROUP1withthetemplate,itwouldhavethree-waymirroring.
B. WhenafileiscreatedinDGROUP1,theMY_TEMPtemplatebecomesthedefaulttemplate.
C. WhenafileiscreatedinDGROUP1withthetemplate,itwouldhavetwo-waymirroringandfilestriping.
D. WhenafileiscreatedinDGROUP1withthetemplate,itwouldhavethree-waymirroringandfilestriping.
E. WhenafileiscreatedinDGROUP1withthetemplate,itwouldhavetwo-waymirroringbutnofileStriping.
WhatwillbetheendresultofthissetofRMANcommands?()shutdownabortstartupmountrestoredatafile4untiltime,,09/30/2008:15:00:00;recoverdatafile4untiltime,,09/29/2008:15:00:00;alterdatabaseopenresetlogs;
A. Datafile4willberecovereduntil9/30/2008at15:00andthedatabasewillopen.
B. Therestorecommandwillfail.
C. Therecovercommandwillfail.
D. Thealterdatabaseopenresetlogscommandwillfail.
E. Allthesecommandswillfailbecausetheymustbeintheconfinesofarunblock.
YouhavelostallyourRMANbackupsetpiecesduetoadiskfailure.Unfortunately,youhaveanautomatedcross-checkscriptthatalsodoesadeleteexpiredbackupsetcommand.Youhaverestoredallthebackupsetpiecesfromtape.Whatcommandwouldyouusetogetthosebackupsetpiecesregisteredintherecoverycatalogandthecontrolfileofthedatabaseagain?()
A. registerdatabase
B. recovercatalog
C. loadbackupset
D. synchmetadata
E. catalogstartwith
Whichofthefollowingdoestherecovercommandnotdo?()
A. Restorearchivedredologs.
B. Applyarchivedredologs.
C. Restoreincrementalbackups.
D. Applyincrementalbackups.
E. Restoredatafileimages.