Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performanc

题目

Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）

A. Database replay

B. SQL Tuning Advisor

C. SQL Access Advisor

D. SQL Performance Analyzer

E. Automatic Workload Repository compare reports

相似考题

1.7． Hi! This is_______ new teacher．__________ name is Linda．A． your; MyB． his; YourC． your ; HerD． her; His

2.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

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

4.合法E－mail地址是()。>A.cne@online.sh.cnB.cne.online.sh.cnC.online.sh.cn@cneD.cn.sh.online.shj

更多“Your database supports an online transaction processing (OLTP) application.The application ”相关问题

  • 第1题：

    合法E－mail地址是()。

    A.shi@online.sh.cn

    B.shj.online.sh.cn

    C.cn.sh.online.shj

    D.Online.sh.cn@shj


    正确答案:A

  • 第2题：

    WhatisakeydifferentiatorbetweenaDS8700andDS8800foracustomerlookingforahighcapacitysolutionatthelowestcost()

    A.DS8700supportsSATAdrives

    B.DS8800supportsmorephysicaldrives

    C.DS8700supports2.5"diskdrives

    D.DS8800supports4GbpsFCdrives


    参考答案：A

  • 第3题：

    （ ） – Is Miss White __________ English teacher, Maria?

    – No, she teaches __________ geography.

    A．your；my

    B．you；mine

    C．you；us

    D．your；us


    正确答案：D

  • 第4题：

    下列E-mail地址合法的是( )

    A．shjkbk@online.sh.cn

    B．shjkbk.online.sh.cn

    C．online.sh.cn@shjkbk

    D．cn.sh.online.shjkbk


    正确答案：A
    解析：用户的电子邮件地址由两部分组成，前一部分为用户在该邮件服务器中的账号，后一部分为邮件服务器的主机名或邮件服务器所在域的域名，中间用“@”分隔。

  • 第5题：

    WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?()

    A.Youcanfindinformationaboutonlyactivetransactionsfromtheview

    B.Youcanfindinformationaboutreadonlytransactionsfromtheview

    C.YourequiretheSELECTANYTRANSACTIONsystemprivilegetoaccesstheview

    D.Youcanfindinformationaboutbothactiveandcommittedtransactionsfromtheview

    E.YourequiretheSELECTONFLASHBACK_TRANSACTION_QUERYobjectprivilegetoaccesstheview


    参考答案：C, D

相关内容