多选题Which two statements about workload capture and replay operations are true？（）AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enabl

题目
多选题
Which two statements about workload capture and replay operations are true？（）
A

The clients must be created manually on the test machines to perform more realistic testing.

B

Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

C

Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

D

The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

相似考题

1.Which two client requests are captured during database replay Capture?()A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations

2.Which two statements about workload capture and replay operations are true?()A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

3.Which two client requests are captured during database replay Capture?() (Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations

4.Which client requests to the database can be captured as a part of the workload capture?()A. flashback queryB. distributed transactionsC. logging in and logging out of sessionsD. all DDL statements having bind variablesE. direct path load of data from external files

参考答案和解析
正确答案： D,A
解析： 暂无解析
更多“Which two statements about workload capture and replay opera”相关问题

  • 第1题：

    Which two statements are true about L2TP tunnels?（） (Choose two.)

    • A、Traffic is clear text
    • B、Traffic is encrypted 
    • C、They are initiated by the LNS
    • D、They are initiated by the LAC

    正确答案:A,D

  • 第2题：

    Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）

    • A、The ADDM requires at least four AWR snapshots for analysis.
    • B、The ADDM runs after each AWR snapshot is collected automatically by MMON.
    • C、The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.
    • D、The ADDM analysis provides only diagnostic information but does not provide recommendations.
    • E、The ADDM calls other advisors if required， but does not provide recommendations about the advisors.

    正确答案:B,C

  • 第3题：

    Which of the following represents the correct sequence of events for Database Replay？（）

    • A、 Capture，analyze，preprocess，replay
    • B、 Capture，preprocess，analyze，replay
    • C、 Capture，preprocess，replay，analyze
    • D、 Analyze，capture，preprocess，replay
    • E、 None of the above

    正确答案:C

  • 第4题：

    In a Database Replay workload capture， what client request information is gathered？（）

    • A、 SQL text
    • B、 Shared server requests （Oracle MTS）
    • C、 Bind variable values
    • D、 Information about transactions
    • E、 Remote DESCRIBE and COMMIT operations

    正确答案:A,C,D

  • 第5题：

    Which client requests to the database can be captured as a part of the workload capture?（）

    • A、flashback query
    • B、distributed transactions
    • C、logging in and logging out of sessions
    • D、all DDL statements having bind variables
    • E、direct path load of data from external files

    正确答案:C,D

  • 第6题：

    Which two client requests are captured during database replay Capture?（） (Choose two)

    • A、Flashback queries
    • B、Shared server requests
    • C、Login and logoff activities of sessions
    • D、Direct path load of data from external files by using utilities such as SQL *loader
    • E、Data definition language (DDL) and data manipulation language (DML) operations

    正确答案:C,E

  • 第7题：

    多选题
    Which two client requests are captured during database replay Capture?（） (Choose two)
    A

    Flashback queries

    B

    Shared server requests

    C

    Login and logoff activities of sessions

    D

    Direct path load of data from external files by using utilities such as SQL *loader

    E

    Data definition language (DDL) and data manipulation language (DML) operations


    正确答案： E,B
    解析： 暂无解析

  • 第8题：

    多选题
    Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）
    A

    The ADDM requires at least four AWR snapshots for analysis.

    B

    The ADDM runs after each AWR snapshot is collected automatically by MMON.

    C

    The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.

    D

    The ADDM analysis provides only diagnostic information but does not provide recommendations.

    E

    The ADDM calls other advisors if required， but does not provide recommendations about the advisors.


    正确答案： A,B
    解析： 暂无解析

  • 第9题：

    单选题
    Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload：   1） Preprocess the captured workload.  2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients.  4） Restore the test database to the point when the capture started.  5） Remap connections.   Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）
    A

     1，4，5，3 （2 is not required.）

    B

     1，4，3，5 （2 is not required.）

    C

     1，2，4，5 （3 is not required.）

    D

     2，1，5，3，4 

    E

     1，2，4，5，3


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    Which client requests to the database can be captured as a part of the workload capture？（）
    A

    flashback query

    B

    distributed transactions

    C

    logging in and logging out of sessions

    D

    all DDL statements having bind variables

    E

    direct path load of data from external files


    正确答案： E,D
    解析： 暂无解析

  • 第11题：

    多选题
    Which two statements about workload capture and replay operations are true?（）
    A

    The clients must be created manually on the test machines to perform more realistic testing.

    B

    Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

    C

    Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

    D

    The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.


    正确答案： D,A
    解析： 暂无解析

  • 第12题：

    多选题
    In a Database Replay workload capture， what client request information is gathered？（）
    A

    SQL text

    B

    Shared server requests （Oracle MTS）

    C

    Bind variable values

    D

    Information about transactions

    E

    Remote DESCRIBE and COMMIT operations


    正确答案： E,B
    解析： 暂无解析

  • 第13题：

    Which two client requests are captured during database replay Capture?（）

    • A、Flashback queries
    • B、Shared server requests
    • C、Login and logoff activities of sessions
    • D、Direct path load of data from external files by using utilities such as SQL *loader
    • E、Data definition language (DDL) and data manipulation language (DML) operations

    正确答案:C,E

  • 第14题：

    Which three statements about performance analysis by SQL Performance Analyzer are true? （）

    • A、It detects changes in SQL execution plans.
    • B、It produces results that can be used to create the SQL plan baseline.
    • C、The importance of SQL statements is based on the size of the objects accessed.
    • D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
    • E、It shows only the overall impact on workload and not the net SQL impact on workload.

    正确答案:A,B,D

  • 第15题：

    Which two statements are true about the Automatic Workload Repository （AWR）（）

    • A、All AWR tables belong to the SYSTEM schema.
    • B、The AWR contains systemwide tracing and logging information.
    • C、The snapshots collected by the AWR are accessible through data dictionary views.
    • D、The snapshots collected by the AWR are used by self-tuning components in the database.

    正确答案:C,D

  • 第16题：

    Which two prerequisites are needed for performing workload capture and replay？（）

    • A、Close all sessions performing queries using database links
    • B、running the database in shared server mode
    • C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
    • D、setting up the directory to capture the workload

    正确答案:C,D

  • 第17题：

    Performance divergence indicated in the Workload Replay report is most likely due to what？（）  

    • A、 DML and SQL statement results that do not match between the capture and replay systems
    • B、 When errors that occur in the capture system dont occur in the replay system
    • C、 Top SQL statements
    • D、 Infrastructure or system-configuration differences
    • E、 Time-of-day differences between capture and replay systems

    正确答案:D

  • 第18题：

    多选题
    Which two statements are true about L2TP tunnels?（） (Choose two.)
    A

    Traffic is clear text

    B

    Traffic is encrypted 

    C

    They are initiated by the LNS

    D

    They are initiated by the LAC


    正确答案： B,D
    解析： 暂无解析

  • 第19题：

    多选题
    Which of these recommendations should be followed before capturing a workload？（）
    A

    Make sure your replay database has the same structure as the capture database， except without data.

    B

    Make sure the replay and capture databases are similar in data content.

    C

    Perform a clean shutdown and restart of the capture database before beginning a workload capture.

    D

    Start the capture database in UNRESTRICTED mode， then start the capture.

    E

    Define inclusion and exclusion filters.


    正确答案： A,B
    解析： 暂无解析

  • 第20题：

    多选题
    Which two prerequisites are needed for performing workload capture and replay？（）
    A

    Close all sessions performing queries using database links

    B

    running the database in shared server mode

    C

    The database on which the workload is replayed has to be a restore of the original database to a specific SCN

    D

    setting up the directory to capture the workload


    正确答案： C,D
    解析： 暂无解析

  • 第21题：

    多选题
    Which two client requests are captured during database replay Capture?（）
    A

    Flashback queries

    B

    Shared server requests

    C

    Login and logoff activities of sessions

    D

    Direct path load of data from external files by using utilities such as SQL *loader

    E

    Data definition language (DDL) and data manipulation language (DML) operations


    正确答案： D,A
    解析： 暂无解析

  • 第22题：

    单选题
    Which of the following represents the correct sequence of events for Database Replay？（）
    A

     Capture，analyze，preprocess，replay

    B

     Capture，preprocess，analyze，replay

    C

     Capture，preprocess，replay，analyze

    D

     Analyze，capture，preprocess，replay

    E

     None of the above


    正确答案： A
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements are true about the Automatic Workload Repository （AWR）（）
    A

    All AWR tables belong to the SYSTEM schema.

    B

    The AWR contains systemwide tracing and logging information.

    C

    The snapshots collected by the AWR are accessible through data dictionary views.

    D

    The snapshots collected by the AWR are used by self-tuning components in the database.


    正确答案： C,B
    解析： AWR 基础结构由两个主要部分组成：  • 一个内存中统计信息收集工具，Oracle Database 11g组件使用它来收集统计信息。出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能(V$) 视图访问存储在内存中的统计信息。  • 代表该工具持久部分的AWR 快照。AWR 快照可以通过数据字典视图和EnterpriseManager Database Control 来访问。  它为内部Oracle 服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和自优化。 AWR 中包含数百个表，所有这些表均属于SYSMAN方案且存储在SYSAUX表空间中。

  • 第24题：

    单选题
    Performance divergence indicated in the Workload Replay report is most likely due to what？（）
    A

     DML and SQL statement results that do not match between the capture and replay systems

    B

     When errors that occur in the capture system dont occur in the replay system

    C

     Top SQL statements

    D

     Infrastructure or system-configuration differences

    E

     Time-of-day differences between capture and replay systems


    正确答案： A
    解析： 暂无解析

相关内容