Youobservethatdatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason，youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto，inordertodeterminetherequiredsizeofthedatabasebuffercache？（）
A. MemoryAdvisor
B. SegmentAdvisor
C. SQLTuningAdvisor
D. SQLAccessAdvisor
E. AutomaticDatabaseDiagnosticMonitor（ADDM）
查看答案
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
微信支付 
支付宝支付