网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Inyourdatabase,theLogWriter(LGWR)processisunabletowritetoamemberofacurrentredologgroupduetoread／writefailure.Whichtwoeffectswouldyouseeinyourdatabase?()
A.Thedatabaseinstanceaborts.
B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.
C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.
D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
参考答案
更多 “ Inyourdatabase,theLogWriter(LGWR)processisunabletowritetoamemberofacurrentredologgroupduetoread／writefailure.Whichtwoeffectswouldyouseeinyourdatabase?() A.Thedatabaseinstanceaborts.B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile. ” 相关考题
考题
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?（）A. authentication by password fileB. authentication by using certificates over SSLC. authentication by using the Oracle Internet DirectoryD. authentication by using the local OS of the database server
考题
Inyourdatabase，allthetablespacesarelocallymanaged.YoustartedRecoveryManager（RMAN）usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand：RMANRESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup？（）A.shutdownandrestarttheinstanceB.addnewtempfilestothetemporarytablespacesafterrecoveryC.performamediarecoveryandopenthedatabasewiththeRESETLOGSoptionD.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode
考题
Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure.Howwouldyourecoverthelostredologmember?()
A.importthedatabasefromthelastexportB.restoreallthemembersinthegroupfromthelastbackupC.dropthelostmemberfromthedatabase，andthenaddanewmembertothegroupD.restoreallthedatabasefilesfromthebackup，andthenperformacompleterecoveryE.restoreallthedatabasefilesfromthebackup，andthenperformanincompleterecovery
考题
WhichbackgroundprocesssequentiallywritesFlashbackDatabasedatafromtheflashbackbuffertotheFlashbackDatabaselogs?()
A.DBWnB.RECOC.RVWRD.LGWR
考题
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?()
A. Setting a metric thresholdB. Implementing Database Resource ManagerC. Enabling resumable timeout for user sessionsD. Decreasing the value of the IDLE_TIME resource limit in the default profile
考题
Inyourdatabase,youdiscoveredthatatempfileinalocallymanagedtemporarytablespacehasbeendeletedattheoperatingsystemlevel.Howwouldyourecoverthetablespace?()
A.flashbackthedatabaseB.performpoint-in-timerecoveryC.performafulldatabaserecoveryD.dropandre-createthetablespaceE.useRecoveryManager（RMAN）torecoverthedatabase
考题
Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure?Howwouldyourecoverthelostredologmember?()
A.importthedatabasefromthelastexportB.restoreallthemembersinthegroupfromthelastbackupC.dropthelostmemberfromthedatabaseandthenaddanewmembertothegroupD.restoreallthedatabasefilesfromthebackupandthenperformacompleterecoveryE.restoreallthedatabasefilesfromthebackupandthenperformanincompleterecovery
考题
TheLogWriter(LGWR)processreadsinformationfromthe()andwritesittotheonlinelogs.
A.largepoolB.sharedpoolC.databuffercacheD.redologbufferE.datadictionarycache
考题
哪个后台进程负责清理出现故障的进程？A．PMONB．SMONC．DBWRD．LGWR
热门标签
最新试卷