多选题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 enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

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


参考解析

解析: 暂无解析

相关考题:

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

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

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.

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

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

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

In a Database Replay workload capture, what client request information is gathered?()A、 SQL textB、 Shared server requests (Oracle MTS)C、 Bind variable valuesD、 Information about transactionsE、 Remote DESCRIBE and COMMIT operations

Which two prerequisites are needed for performing workload capture and replay?()A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload

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

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 systemsB、 When errors that occur in the capture system dont occur in the replay systemC、 Top SQL statementsD、 Infrastructure or system-configuration differencesE、 Time-of-day differences between capture and replay systems

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.

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.

多选题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?()AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation

多选题Which two client requests are captured during database replay Capture?()AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language (DDL) and data manipulation language (DML) operations

多选题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.)()AThe database must be opened in restricted mode.BThe database must be configured to run in ARCHIVELOG mode.CThe tablespaces are required to be in backup mode before taking the backup.DThe tablespaces are required to be in read-only mode before taking the backup

多选题Which two statements are correct about database transportation? ()AThe source and target platforms must be the sameBRedo logs, control files and temp files are also transportedCThe transported database must have the same database identifier (DBID) as the source database and cannot be changedDThe COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedERecovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

多选题Which two statements are correct about database transportation?() (Choose two.)AThe source and target platforms must be the sameBRedo logs, control files and temp files are also transportedCThe transported database must have the same database identifier (DBID) as the source database and cannot be changedDThe COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedERecovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

多选题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 enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

多选题Which two prerequisites are needed for performing workload capture and replay?()AClose all sessions performing queries using database linksBrunning the database in shared server modeCThe database on which the workload is replayed has to be a restore of the original database to a specific SCNDsetting up the directory to capture the workload

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

多选题In a Database Replay workload capture, what client request information is gathered?()ASQL textBShared server requests (Oracle MTS)CBind variable valuesDInformation about transactionsERemote DESCRIBE and COMMIT operations

多选题Which of these recommendations should be followed before capturing a workload?()AMake sure your replay database has the same structure as the capture database, except without data.BMake sure the replay and capture databases are similar in data content.CPerform a clean shutdown and restart of the capture database before beginning a workload capture.DStart the capture database in UNRESTRICTED mode, then start the capture.EDefine inclusion and exclusion filters.

单选题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 systemsB When errors that occur in the capture system dont occur in the replay systemC Top SQL statementsD Infrastructure or system-configuration differencesE Time-of-day differences between capture and replay systems

多选题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.()AThe database must be opened in restricted mode.BThe database must be configured to run in ARCHIVELOG mode.CThe tablespaces are required to be in backup mode before taking the backup.DThe tablespaces are required to be in read-only mode before taking the backup

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

多选题Which two statements are true regarding the database in ARCHIVELOG mode?()AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

多选题Which two client requests are captured during database replay Capture?() (Choose two)AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language (DDL) and data manipulation language (DML) operations

多选题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?()AThe database must have multiplexed redo logs for the flashback to succeed.BThe database must be MOUNTED for the flashback to succeed.CThe database must use block change tracking for the flashback to succeed.DThe database must be opened in restricted mode for the flashback to succeed.EThe database must be opened with the RESETLOGS option after the flashback is complete.FThe database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.