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
WhichthreestatementsaretrueregardingthelogicalstructureoftheOracledatabase？（）
A. Eachsegmentcontainsoneormoreextents.
B. Multipletablespacescansharesingledatafile.
C. AdatablockisthesmallestunitofI/Ofordatafiles.
D. Itispossibletohavetablespacesofdifferentblocksizesinadatabase.
EachdatablockinthedatabasealwayscorrespondstooneOSblock.
微信支付 
支付宝支付