DML and SQL statement results that do not match between the capture and replay systems
When errors that occur in the capture system dont occur in the replay system
Top SQL statements
Infrastructure or system-configuration differences
Time-of-day differences between capture and replay systems
第1题:
You need to design a strategy to log access to the company Web site. What should you do?()
第2题:
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?()
第3题:
Which two prerequisites are needed for performing workload capture and replay?()
第4题:
Which two client requests are captured during database replay Capture?()
第5题:
Which two statements about workload capture and replay operations are true?()
第6题:
Which of these recommendations should be followed before capturing a workload?()
第7题:
Enable logging on the company Web site and select the NCSA Common Log File Format. Store the log files on a SQL Server computer
Use System Monitor to create a counter log that captures network traffic to the Web server by using the Web Service object. Store the log files on a SQL Server computer
Run the Network Monitor on the Web server. Create a capture filter for the SNA protocol and save the results to a capture file. Store the capture file on a SQL Server computer
Enable logging on the company Web site and select ODBC Logging. Configure the ODBC logging options by using a nonadministrative SQL account
第8题:
Excessive pitching
Excessive yawing
Excessive rolling
No change should be evident
第9题:
The clients must be created manually on the test machines to perform more realistic testing.
Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
第10题:
Capture,analyze,preprocess,replay
Capture,preprocess,analyze,replay
Capture,preprocess,replay,analyze
Analyze,capture,preprocess,replay
None of the above
第11题:
Configure event log subscriptions.
Start the System Performance data collector set.
Start the Active Directory Diagnostics data collector set.
Install Network Monitor and create a new capture.
第12题:
1,4,5,3 (2 is not required.)
1,4,3,5 (2 is not required.)
1,2,4,5 (3 is not required.)
2,1,5,3,4
1,2,4,5,3
第13题:
Which of the following represents the correct sequence of events for Database Replay?()
第14题:
In a Database Replay workload capture, what client request information is gathered?()
第15题:
Performance divergence indicated in the Workload Replay report is most likely due to what?()
第16题:
Which two client requests are captured during database replay Capture?() (Choose two)
第17题:
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()
第18题:
Certkiller .com has a network that consists of a single Active Directory domain.Windows Server 2008 is installed on all domain controllers in the network. You are instructed to capture all replication errors from all domain controllers to a central location. What should you do to achieve this task()
第19题:
Flashback queries
Shared server requests
Login and logoff activities of sessions
Direct path load of data from external files by using utilities such as SQL *loader
Data definition language (DDL) and data manipulation language (DML) operations
第20题:
configure event log subscriptions.
Start the System Performance data collector set.
start the Active Directory Diagnostics data collector set.
Install Network Monitor and create a new a new capture.
第21题:
Close all sessions performing queries using database links
running the database in shared server mode
The database on which the workload is replayed has to be a restore of the original database to a specific SCN
setting up the directory to capture the workload
第22题:
SQL text
Shared server requests (Oracle MTS)
Bind variable values
Information about transactions
Remote DESCRIBE and COMMIT operations
第23题:
DML and SQL statement results that do not match between the capture and replay systems
When errors that occur in the capture system dont occur in the replay system
Top SQL statements
Infrastructure or system-configuration differences
Time-of-day differences between capture and replay systems
第24题:
Flashback queries
Shared server requests
Login and logoff activities of sessions
Direct path load of data from external files by using utilities such as SQL *loader
Data definition language (DDL) and data manipulation language (DML) operations