Whenperformingadatabaseduplication,whichduplicatedatabaseparameterwouldyousettoensurethattheonlineredologsarecreatedinthecorrectlocation?()
A. log_file_name_convert
B. convert_log_file_name
C. file_name_convert_log
D. redo_log_file_name_convert
E. logfile_convert_directory
查看答案
Which constraint can be defined only at the column level? ()
A. UNIQUE
B. NOT NULL
CHECK
D. PRIMARY KEY
E. FOREIGN KEY
WhichofthefollowingcanbeusedinconjunctionwithaFlashbackVersionsQuerytofiltertheresults?()
ArangeofSCNvalues
B. AlistofSCNvalues
C. Astartingandendingtimestamp
D. Minimumandmaximumsequencevalues
E. Alistofsequencevalues
WhichthreestatementsaretrueregardingthelogicalstructureoftheOracledatabase?()
A. Eachsegmentcontainsoneormoreextents.
B. Multipletablespacescansharesingledatafile.
C. AdatablockisthesmallestunitofI/Ofordatafiles.
D. Itispossibletohavetablespacesofdifferentblocksizesinadatabase.
EachdatablockinthedatabasealwayscorrespondstooneOSblock.
Yourdatabaseisupandrunningandoneofyourthreecontrolfilesisaccidentallyerased.YoustartRMANandrunthefollowingcommand:RESTORECONTROLFILEFROMAUTOBACKUP;Whichofthefollowingstatementsistrue?()
A. Thecommandrestoresonlythemissingcontrolfile.
B. Thecommandrestoresallthecontrolfiles.
C. Thecommandfailsbecausethedatabaseisrunning.
D. Thisisthecorrectwaytoaddressthisproblem.
E. Thisisnotthecorrectwaytoaddressthisproblem.