单选题You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your sug

第1题：

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.

第2题：

You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）

• A、owner
• B、touser
• C、include
• D、schemas
• E、fromuser
• F、transform
• G、remap_schema
• H、remap_datafile
• I、reuse_datafiles
• J、remap_tablespace

第3题：

You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

• A、Run Segment Advisor
• B、Run the SQL Tuning Advisor (STA)
• C、Run the Automatic Workload Repository (AWR) report
• D、Run the SQL Access Advisor with a hypothetical workload

第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？（）

• A、 the SQL text
• B、 the execution plan
• C、 the execution context
• D、 the execution frequency
• E、 the system change number （SCN）

第5题：

In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information.  What action would you take to achieve this task（）

• A、Apply fine-grained auditing.
• B、Implement value-based auditing.
• C、Impose standard database auditing to auditobject privileges.
• D、Impose standard databaseauditing to audit SQL statements.

第6题：

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?（）

• A、the SQL text SQL
• B、the execution plan
• C、the execution context
• D、the execution frequency
• E、the system change number (SCN)

第7题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement？（） 

• A、You should create a cached data collection
• B、You should create an on-demand non-cached data collection 
• C、You should create a scheduled non-cached data collection 
• D、You should create two different SQL Agent jobs that are scheduled stimultaneously

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）

• A、Memory Advisors
• B、Segment Advisors
• C、SQL Tuning and Access Advisors
• D、Automated Workload Repository （AWR）
• E、Automatic Database Diagnostic Monitor （ADDM）

第14题：

You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

• A、 Top SQL
• B、 snapshots
• C、 SQL Tuning sets
• D、 index access path
• E、 optimizer statistics
• F、 materialized view logs

第15题：

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

• A、Database replay
• B、SQL Tuning Advisor
• C、SQL Access Advisor
• D、SQL Performance Analyzer
• E、Automatic Workload Repository compare reports

第16题：

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.

第17题：

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

第18题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.  So what action should you perform to achieve this goal？（）

• A、You should recapture the workload by using the data collector.
• B、You should enable the XP_MSVER stored procedure on the local server.
• C、You should enable the XP_MSVER stored procedure on the remote server
• D、You should recapture the workload to a trace file by using SQL Profiler.

第19题：

第20题：

第21题：

第22题：

第23题：