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


参考答案:E, F

第2题:

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

第3题:

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

第4题:

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

第5题:

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

第6题:

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

第7题:

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

第8题:

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

第9题:

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

第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

正确答案:D

更多相关问题