题目内容

TheDB_BLOCK_CHECKINGinitializationparameterissettoTRUE.Whatwouldbetheresultofthissettingonthedatablocksbeingwrittentothedatafiles,everytimetheDBWnwrites?()

A. TheOracledatabasewillcheckalldatablocksbygoingthroughthedataoneachblock,makingsurethedataisself-consistent.
B. TheDBWnandthedirectloaderwillcalculateachecksumandstoreitinthecacheheaderofeverydatablockwhenwritingittodisk.
C. TheOracledatabasewillcheckdatablocksbelongingtotheSYSTEMtablespaceonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent.
D. TheOracledatabasewillcheckdatablocksbelongingtotheSYSAUXtablespaceonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent.
E. TheOracledatabasewillcheckdatablocksintheSYSTEMandSYSAUXtablespacesonly,bygoingthroughthedataoneachblock,makingsurethedataisself-consistent.

查看答案
更多问题

可持续发展战略的根本目的是实现()

A. 生态可持续发展
B. 经济可持续发展
C. 社会可持续发展
D. 环境可持续发展

Whichbuilt-inreturnsaBOOLEANvaluethatindicatedwhetheranobjectsinternalIDisavailable?()

A. GET_ID
B. ID_NULL
C. ID_FIND
D. FIND_ID

WhilecreatingajobclassusingtheDBMS_SCHEDULERpackage,yousettheloggingleveltoLOGGING_RUNS.Whatwouldbetheimpactofthissetting?()

A. OracleSchedulerwouldwritedetailedinformationtothejoblogforeachrunofeachjobinthejobclass.
B. OracleSchedulerwouldwritedetailedinformationtothejoblogforthefirstrunofeachjobinthejobclass.
C. OracleSchedulerwouldwritedetailedinformationtothejoblogforeachrunofonlythefirstjobinthejobclass.
D. OracleSchedulerwouldwritedetailedinformationforalloperationsperformedonalljobsinthejobclass.

YouworkasadatabaseadministratorforCertkiller.com.Redologfilesarenotmultiplexedinyourdatabase.Redologblocksarecorruptedingroup2,andarchivinghasstopped.Alltheredologsarefilledanddatabaseactivityishalted.Databasewriterhaswritteneverythingtodisk.Whichcommandwouldyouexecutetoproceedfurther?()

A. RECOVERLOFIELBLOCKGROUP2;
B. ALTERDATABASEDROPLOGFILEGROUP2;
C. ALTERDATABASECLEARLOGFILEGROUP2;
D. ALTERDATABASERECOVERLOGFILEGROUP2;
E. ALTERDATABASECLEARUNARCHIVEDLOGFILEGROUP2;

答案查题题库