WhyshouldyoubackupaduplicatedtablespaceafteraTSPITRiscomplete?()
A. Thetablespacecannotbeduplicatedorrestoredtoanypointintimeaftertheduplication.
B. Thetablespacecannotbeduplicatedorrestoredtothepointintimebeforetheduplication.
C. TheentiredatabasecannotberestoredafteraTSPITR,soabackupisrequired.
D. Youcannotbringthetablespaceonlineuntilitsbeenbackedup.
E. Thereisnorequirementtodoso,asRMANwillbackupthetablespaceaftertheTSPITR.
查看答案
WhichtwostatementsaretrueaboutSharedSQLAreaandPrivateSQLAreas()
A. SharedSQLAreawillbeallocatedinthesharedpool.
B. SharedSQLAreawillbeallocatedwhenasessionstarts.
C. SharedSQLAreawillbeallocatedinthelargepoolalways.
D. ThewholeofPrivateSQLAreawillbeallocatedintheProgramGlobalArea(PGA)always.
E. SharedSQLAreaandPrivateSQLAreawillbeallocatedinthePGAorlargepool.
F. ThenumberofPrivateSQLAreaallocationsisdependentontheOPEN_CURSORSparameter.
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