to minimize plan regression due to the use of a new optimizer version
to completely avoid the use of new plans generated by a new optimizer version
to prevent plan capturing when the SQL statement is executed after the database upgrade
to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
第1题:
A. A single SQL statement provided by a user
B. An existing SQL Tuning Set (STS)
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources
第2题:
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?()
第3题:
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? ()
A. to minimize plan regression due to the use of a new optimizer version
B. to completely avoid the use of new plans generated by a new optimizer version
C. to prevent plan capturing when the SQL statement is executed after the database upgrade
D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
第4题:
Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade,you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of executing this script?()
第5题:
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?()
第6题:
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?()
第7题:
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?()
第8题:
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
第9题:
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?()
第10题:
Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)