the SQL text SQL
the execution plan
the execution context
the execution frequency
the system change number (SCN)
第1题:
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()
A.Every SQL statement in the STS is considered only once for execution
B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
C.The execution plan and execution statistics are computed for each SQL statement in the STS
D.The effects of DDL and DML are considered to produce the execution plan and execution statistics
第2题:
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?()
A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
B. Run the Automatic Workload Repository Monitor (ADDM).
C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
第3题:
A. the SQL text SQL
B. the execution plan
C. the execution context
D. the execution frequency
E. the system change number (SCN)
第4题:
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?()
第5题:
You are analyzing the performance of a SQL Azure database. You need to recommend an approach for identifying the indexes that should be added to improve database performance. What should you recommend?()
第6题:
A. Change in the Oracle Database version
B. Change in your network infrastructure
C. Change in the hardware configuration of the database server
D. Migration of database storage from non-ASM to ASM storage
E. Database and operating system upgrade
第7题:
Which three statements about performance analysis by SQL Performance Analyzer are true? ()
第8题:
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()
A. The tuned plan is not added to the SQL plan baseline.
B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
第9题:
A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend?()
第10题:
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()