多选题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.You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE －5／24);Which two statements are true about this?()A. The database must have multiplexed redo log filesB. The database must be in the MOUNT state to execute the commandC. The database must be in the NOMOUNT state to execute the commandD. The database must be opened in RESTRICTED mode before this operationE. The database must be opened with the RESETLOGS option after the flashback operation

2.You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?()A. The database must have multiplexed redo logs for the flashback to succeed.B. The database must be MOUNTED for the flashback to succeed.C. The database must use block change tracking for the flashback to succeed.D. The database must be opened in restricted mode for the flashback to succeed.E. The database must be opened with the RESETLOGS option after the flashback is complete.F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

3.Which of the following represents the correct sequence of events for Database Replay？（）A、 Capture，analyze，preprocess，replayB、 Capture，preprocess，analyze，replayC、 Capture，preprocess，replay，analyzeD、 Analyze，capture，preprocess，replayE、 None of the above

4.You are managing a 24*7 database. The backup strategy for the database is to perform user－managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tablespaces are required to be in backup mode before taking the backup.D. The tablespaces are required to be in read-only mode before taking the backup

更多“多选题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”相关问题

  • 第1题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第2题：

    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

  • 第3题：

    You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）

    • A、The database must be opened in restricted mode.
    • B、The database must be configured to run in ARCHIVELOG mode.
    • C、The tablespaces are required to be in backup mode before taking the backup.
    • D、The tablespaces are required to be in read-only mode before taking the backup

    正确答案:B,C

  • 第4题：

    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.

    正确答案:C,D

  • 第5题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


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

  • 第6题：

    多选题
    You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）
    A

    The database must be opened in restricted mode.

    B

    The database must be configured to run in ARCHIVELOG mode.

    C

    The tablespaces are required to be in backup mode before taking the backup.

    D

    The tablespaces are required to be in read-only mode before taking the backup


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

  • 第7题：

    多选题
    Which two statements are correct about database transportation?（） (Choose two.)
    A

    The source and target platforms must be the same

    B

    Redo logs, control files and temp files are also transported

    C

    The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D

    The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E

    Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


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

  • 第8题：

    多选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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


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

  • 第12题：

    多选题
    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
    解析： 暂无解析

  • 第13题：

    You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）

    • A、The database must be opened in restricted mode.
    • B、The database must be configured to run in ARCHIVELOG mode.
    • C、The tablespaces are required to be in backup mode before taking the backup.
    • D、The tablespaces are required to be in read-only mode before taking the backup

    正确答案:B,C

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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.

    正确答案:B,C

  • 第17题：

    多选题
    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
    解析： 暂无解析

  • 第18题：

    多选题
    Which two statements are correct about database transportation? （）
    A

    The source and target platforms must be the same

    B

    Redo logs, control files and temp files are also transported

    C

    The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D

    The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E

    Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


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

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    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


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

  • 第21题：

    多选题
    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.


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

  • 第22题：

    多选题
    You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）
    A

    The database must be opened in restricted mode.

    B

    The database must be configured to run in ARCHIVELOG mode.

    C

    The tablespaces are required to be in backup mode before taking the backup.

    D

    The tablespaces are required to be in read-only mode before taking the backup


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

  • 第23题：

    多选题
    Which two statements are true regarding the database in ARCHIVELOG mode？（）
    A

    You have to shut down the database to perform the backups.

    B

    Archiving information is written to the data files and redo log files.

    C

    You can perform complete database backups without closing the database.

    D

    Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

    E

    All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.


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

  • 第24题：

    多选题
    You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）
    A

    The database must have multiplexed redo logs for the flashback to succeed.

    B

    The database must be MOUNTED for the flashback to succeed.

    C

    The database must use block change tracking for the flashback to succeed.

    D

    The database must be opened in restricted mode for the flashback to succeed.

    E

    The database must be opened with the RESETLOGS option after the flashback is complete.

    F

    The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.


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

相关内容