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.
YouperformabackupusingthefollowingBACKUPcommand:RMAN>BACKUPASCOMPRESSEDBACKUPSETDATABASE,Whichstatementistrueofthiscommand?()
Adifferentprocedureisrequiredtorestoreadatabasefromcompressedbackups
B. TheASCOMPRESSEDclauseoftheBACKUPcommandprovidedbyRMANisusedtocreatecompressedbackupsetsandimagecopies.
C. Usingthiscommandtocreatebackupsminimizesthebandwidthconsumed.
D. Usingthiscommandtocreatebackupsimprovestheperformanceofthebackupprocess
InSolaris10,thistoolprovidesanautomatedandproactiveapproachtopatchmanagement.Itprovidesagraphicaluserinterfaceaswellasacommandlineinterface.Whichtoolisit?()
A. smpatch
B. Patchtool
C. Updatemanager
D. Patchmanager