网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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.
热门标签
最新试卷