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.

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.


相关考题:

Youexecutedthefollowingcode:SQLCREATETABLECOUNTRY(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)

Youexecutedthefollowingcode:SQLCERATETABLECOUNTRY(COUNTRY_IDCHAR(2)CONSTRAINTCOUNTRY_ID_nnNOTNULL,COUNTRY_NAMEVARCHAR2(20),CURRENCY_NAMEVARCHAR2(20),CONSTRAINTCOUNTRY_ID_PKPRIMARYKEY(COUNTRY_ID))ORGANIZATIONINDEX;Whichtypesoftableswillbecreatedautomatically?()A.journaltableB.clusteredtableC.mappingtableD.partitionedtable

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.

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.

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.