Youexecutedthefollowingcode:BACKUPVALIDATEDATABASE;BLOCKRECOVERCORRUPTIONLIST;Whatwillbetheresultofexecutingtheabovecode?()A.ThecodewillrunabackupvalidationtopopulatetheV$BACKUP_CORRUPTIONviewandrepaircorruptblocks，ifany，recordedintheview.B.Thecodewillrun

题目
Youexecutedthefollowingcode:BACKUPVALIDATEDATABASE;BLOCKRECOVERCORRUPTIONLIST;Whatwillbetheresultofexecutingtheabovecode?()

A.ThecodewillrunabackupvalidationtopopulatetheV$BACKUP_CORRUPTIONviewandrepaircorruptblocks，ifany，recordedintheview.

B.ThecodewillrunabackupvalidatetopopulatetheV$COPY_CORRUPTIONviewandthenrepairanycorruptblocksrecordedintheview.

C.ThecodewillrunsabackupvalidatetopopulatetheV$DATABASE_BLOCK_CORRUPTIONviewandthenrepaircorruptblocks，ifany，recordedintheview.

D.ThecodewillrunabackupvalidatetopopulatetheRC_BACKUP_CORRUPTIONviewandthenrepaircorruptblocks，ifany，recordedintheview.

相似考题

1.Youexecutedthefollowingcode：SQL>CREATETABLECOUNTRY（COUNTRY_IDCHAR（2）CONSTRAINTCOUNTRY_ID_nnNOTNULL，COUNTRY_NAMEVARCHAR2（20），CURRENCY_NAMEVARCHAR2（20），CONSTRAINTCOUNTRY_ID_PKPRIMARYKEY（COUNTRY_ID））ORGANIZATIONINDEX；Inwhichtablespacewillthemappingtablebecreated？（）A.SYSTEMtablespaceB.SYSAUXtablespaceC.UndotablespaceD.ThetablespaceoftheIndexOrganizedTable（IOT）

2.Youexecutedthefollowingcode:BEGINDBMS_SCHEDULER.SET_ATTRIBUTE(NAME=>’JOB_A’,ATTRIBUTE=>’JOB_PRIORITY’,VALUE=>7);END;／Afteranalyzingtheabovecode,whatconclusionwillyoudraw?()A.Thecodewillbeexecutedsuccessfully.B.ThecodewillnotbeexecutedsuccessfullybecausethevalueoftheVALUEparametermustbe1，2，or3.C.ThecodewillnotbeexecutedsuccessfullybecausethevalueoftheVALUEparametermustrangebetween1and5.D.ThecodewillnotbeexecutedsuccessfullybecausenoSET_ATTRIBUTEprocedureexistsintheDBMS_SCHDULERpackage.

3.Youissuethefollowingcode:EXECDBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(’SCOTT’’GRP1’,TRUE);Whatwillbetheresultofexecutingtheabovecode?()A.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergrouptoGRP1.B.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergroupfromGRP1toanyothergroup.C.ThecodewillnotexecutesuccessfullybecausethereisnoGRANT_SWITCH_CONSUMER_GROUPprocedureintheDBMS_RESOURCE_MANAGER_PRIVSpackage.D.Thecodewillexecutesuccessfullybutnoprivilegewillbegrantedtotheuser，Scott.

4.Youexecutedthefollowingcode：SQL>CERATETABLECOUNTRY（COUNTRY_IDCHAR（2）CONSTRAINTCOUNTRY_ID_nnNOTNULL，COUNTRY_NAMEVARCHAR2（20），CURRENCY_NAMEVARCHAR2（20），CONSTRAINTCOUNTRY_ID_PKPRIMARYKEY（COUNTRY_ID））ORGANIZATIONINDEX；Whichtypesoftableswillbecreatedautomatically？（）A.journaltableB.clusteredtableC.mappingtableD.partitionedtable

参考答案和解析
参考答案：C
更多“Youexecutedthefollowingcode:BACKUPVALIDATEDATABASE;BLOCKRECOVERCORRUPTIONLIST;Whatwillbetheresultofexecutingtheabovecode?() ”相关问题

  • 第1题：

    YouexecutethefollowingRMANcommandintheordershownbelow:BACKUPVALIDATEDATABASE;BLOCKRECOVERCORRUPTIONLIST;Whatwillthesecommandsdo?()

    A.Createabackupofthedatabaseandrecoverallcorruptedblocksfoundinthebackup.

    B.Runabackupvalidationandlistallthelogicallycorruptblocksaswellasphysicallycorruptblocksinthedatabase.

    C.RunabackupvalidationtopopulateV$COPY_CORRUPTIONview，andthenlistanycorruptblocksrecordedintheview.

    D.RunabackupvalidationtopopulateV$DATABASE_BLOCK_CORRUPTIONview，andthenrepairanycorruptblocksrecordedintheview.

    E.Runabackupvalidation，repairanycorruptblocksfoundduringthevalidationprocess，andthenupdateV$DATABASE_BLOCK_CORRUPTIONviewtoindicatewhichcorruptblockshavebeenrepaired.


    参考答案：D

相关内容