网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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 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.” 相关考题
考题
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()
A. Multiple change tracking files can be created for a database.B. The change tracking file must be created after the first level 0 backup.C. RMAN does not support backup and recovery of the change tracking file.D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
考题
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
考题
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 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
考题
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()A、Multiple change tracking files can be created for a database.B、The change tracking file must be created after the first level 0 backup.C、RMAN does not support backup and recovery of the change tracking file.D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
考题
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 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
考题
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? ()(Choose two.)A、Multiple change tracking files can be created for a database.B、The change tracking file must be created after the first level 0 backup.C、RMAN does not support backup and recovery of the change tracking file.D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
考题
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.
考题
多选题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
考题
多选题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
考题
多选题To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? ()(Choose two.)AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again, after whole database restore and recovery 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 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
热门标签
最新试卷