多选题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.
参考解析
解析：
暂无解析
相关考题：
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
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
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 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
Which two statements are true about L2TP tunnels?（） (Choose two.)A、Traffic is clear textB、Traffic is encryptedC、They are initiated by the LNSD、They are initiated by the LAC
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
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.
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.
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
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.
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
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
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
多选题Which two statements are true about L2TP tunnels?（） (Choose two.)ATraffic is clear textBTraffic is encryptedCThey are initiated by the LNSDThey are initiated by the LAC
多选题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
多选题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.
多选题Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.DThe ADDM analysis provides only diagnostic information but does not provide recommendations.EThe ADDM calls other advisors if required， but does not provide recommendations about the advisors.
多选题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
单选题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?（）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 client requests to the database can be captured as a part of the workload capture？（）Aflashback queryBdistributed transactionsClogging in and logging out of sessionsDall DDL statements having bind variablesEdirect path load of data from external files
单选题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
多选题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 are true about the Automatic Workload Repository （AWR）（）AAll AWR tables belong to the SYSTEM schema.BThe AWR contains systemwide tracing and logging information.CThe snapshots collected by the AWR are accessible through data dictionary views.DThe snapshots collected by the AWR are used by self-tuning components in the database.
多选题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
单选题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