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

题目

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.

相似考题

1.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.

2.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

3.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）.

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

参考答案和解析
参考答案：A, D
更多“You administer an online transaction processing (OLTP) system whose database is stored in ”相关问题

  • 第1题：

    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, SYSTEM

    B. SCOTT

    C. Only for successful executions

    D. Only for failed executions

    E. Both successful and failed executions


    参考答案：A, E

  • 第2题：

    WhichscriptmustyoutoquerytodisplaythecodeassociatedwithRMANstoredscripts?()

    A.RC_STORED_SCRIPT

    B.RC_STORED_SCRIPT_LINE

    C.RC_SCRIPTS

    D.RC_STORED_LINE_SCRIPT

    E.Noneoftheotheralternativesapply


    参考答案：B

  • 第3题：

    某用户的E-mail地址为you87@online.sh.cn，则该用户的用户名为( )。

    A.you87

    B.online

    C.sh

    D.online.sh.cn


    正确答案：A


  • 第4题：

    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 SYS

    B. All users except SCOTT

    C. All users except sys and SCOTT

    D. All users except sys, system, and SCOTT


    参考答案：B

  • 第5题：

    合法E－mail地址是()。

    A.shi@online.sh.cn

    B.shj.online.sh.cn

    C.cn.sh.online.shj

    D.Online.sh.cn@shj


    正确答案:A

  • 第6题：

    WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?()

    A.Youcanfindinformationaboutonlyactivetransactionsfromtheview

    B.Youcanfindinformationaboutreadonlytransactionsfromtheview

    C.YourequiretheSELECTANYTRANSACTIONsystemprivilegetoaccesstheview

    D.Youcanfindinformationaboutbothactiveandcommittedtransactionsfromtheview

    E.YourequiretheSELECTONFLASHBACK_TRANSACTION_QUERYobjectprivilegetoaccesstheview


    参考答案：C, D

相关内容