YouareusingRecoverywizardforperformingincompleterecovery.WhichofthefollowingobjecttypesisNOTavailableinthePerformRecovery：Typescreen？（）
A. Wholedatabase
B. Tablespaces
C. Datafiles
D. Archivelogs
E. Redologs
查看答案
YouareusingthebackupschedulerinEnterpriseManager（EM）toscheduleabackupofyourdatabase.Whichtypeofscriptdoesthebackupschedulergenerate？（）
A. SQLscript
B. PL/SQLscript
C. OperatingSystem（OS）script
D. EnterpriseManager（EM）script
E. RecoveryManager（RMAN）script
TheDB_BLOCK_CHECKINGinitializationparameterissettoOFF.数据库块检测初始化参数被设定为关Whichblockcheckingwouldbeperformed？（）
A. TheOracledatabasewillperformblockcheckingfortheindexblocksonly
B. TheOracledatabasewillnotperformblockcheckingforanyofthedatablocks
C. TheOracledatabasewillperformblockcheckingforthedefaultpermanenttablespaceonly
D. TheOracledatabasewillperformblockcheckingforthedatablocksinallusertablespaces
E. TheOracledatabasewillperformblockcheckingforthedatablocksintheSYSTEMtablespaceonlyOracle
Youexecutedthefollowingcommands：SQL＞ALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQL＞EXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQL＞EXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）
A. Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.
B. Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.
C. Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.
D. Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.
WhichtwostatementsaboutFlashbackQueryaretrue？（）
A. Itisgeneratedbyusingtheredologfiles.
B. Ithelpsinrow-levelrecoveryfromusererrors.
C. ItcanbeperformedtorecoverALTERTABLEstatements
D. Itfailswhenundodatapertainingtothetransactionisoverwritten.
E. ThedatabasehastobeopenedwiththeresetlogsoptionafterperformingFlashbackQuery.
微信支付 
支付宝支付