You administer an online transaction processing (OLTP) system whose database is stored in AutomaticStorage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failurehappens again?（）A. Increase the value of the ASM_POWER_LIMIT parameter.B. Set the DISK_REPAIR_TIME disk attribute to a lower value.C. Specify the statement that adds the disk back to the disk group.D. Increase the number of ASMB processes.E. Increase the number of DBWR_IO

网友您好，请在下方输入框内输入要搜索的题目：

题目内容（请给出正确答案）

You administer an online transaction processing (OLTP) system whose database is stored in AutomaticStorage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failurehappens again?（）

A. Increase the value of the ASM_POWER_LIMIT parameter.

B. Set the DISK_REPAIR_TIME disk attribute to a lower value.

C. Specify the statement that adds the disk back to the disk group.

D. Increase the number of ASMB processes.

E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

参考答案

更多 “ You administer an online transaction processing (OLTP) system whose database is stored in AutomaticStorage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failurehappens again?（）A. Increase the value of the ASM_POWER_LIMIT parameter.B. Set the DISK_REPAIR_TIME disk attribute to a lower value.C. Specify the statement that adds the disk back to the disk group.D. Increase the number of ASMB processes.E. Increase the number of DBWR_IO_SLAVES in the ASM instance. ” 相关考题

考题 Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?() A. PLSQL_BLOCKB. JAVA_STORED_PROCEDUREC. STORED_PROCEDURED. EXECUTABLEE. None of the above are invalid settings.

查看答案

考题 Which of the following are valid program types for a lightweight job?() A. PLSQL_BLOCK PLSQLB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNAL

查看答案

考题 At10：30A.M.，youranabatchjobbymistake，whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11：10A.M.，youstoppedthebatchjob.Now，youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery？（）A.DBA_PENDING_TRANSACTIONSB.DBA_AUDIT_STATEMENTC.V$FLASHBACK_DATABASE_STATSD.FLASHBACK_TRANSACTION_QUERY

查看答案

考题 Youareworkingonanonlinetransactionprocessing（OLTP）system.YounoticethataPL/SQLproceduregotexecutedtwiceat2）00p.m.ThishasincorrectlyupdatedtheEMP_SALtable.Howwouldyourevertthetabletoitsstateat2）00p.m.？（）A.Performpoint-in-timerecoveryto2：00p.m.B.UseFlashbackTablefeaturetorevertthechanges.C.Restoretheentiredatabasefromtherecentbackupandopenit.D.Issuetherollbackstatementwithsystemchangenumber（SCN）.

查看答案

考题 You enabled an audit policy by issuing the following statements:SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? （）A. SYS, SYSTEMB. SCOTTC. Only for successful executionsD. Only for failed executionsE. Both successful and failed executions

查看答案

考题 You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?（）A. All users except SYSB. All users except SCOTTC. All users except sys and SCOTTD. All users except sys, system, and SCOTT

查看答案

考题 WhichscriptmustyoutoquerytodisplaythecodeassociatedwithRMANstoredscripts?() A.RC_STORED_SCRIPTB.RC_STORED_SCRIPT_LINEC.RC_SCRIPTSD.RC_STORED_LINE_SCRIPTE.Noneoftheotheralternativesapply

查看答案

考题合法E－mail地址是()。 A.shi@online.sh.cnB.shj.online.sh.cnC.cn.sh.online.shjD.Online.sh.cn@shj

查看答案

考题某用户的E-mail地址为you87@online.sh.cn，则该用户的用户名为( )。A.you87B.onlineC.shD.online.sh.cn

查看答案

考题 WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?() A.YoucanfindinformationaboutonlyactivetransactionsfromtheviewB.YoucanfindinformationaboutreadonlytransactionsfromtheviewC.YourequiretheSELECTANYTRANSACTIONsystemprivilegetoaccesstheviewD.YoucanfindinformationaboutbothactiveandcommittedtransactionsfromtheviewE.YourequiretheSELECTONFLASHBACK_TRANSACTION_QUERYobjectprivilegetoaccesstheview

查看答案

热门标签

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：