题目内容

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

答案查题题库