单选题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 suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）ARun the SQL Access Advisor.BRun the SQL Tuning Advisor （STA）.CRun the Automatic Workload Repository （AWR） report.DRun the Automatic Database Diagnostic Monitor （ADDM）.
单选题
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 suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
A
Run the SQL Access Advisor.
B
Run the SQL Tuning Advisor （STA）.
C
Run the Automatic Workload Repository （AWR） report.
D
Run the Automatic Database Diagnostic Monitor （ADDM）.
参考解析
解析：
暂无解析
相关考题：
Before sending your resume to prospective employersor scheduling any interviews , you need to analyze the job market. Analyzing the job market involves determining actual jobopenings and gathering information about organizations for which you want to work.
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 SQLB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN)
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 executionB.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC.The execution plan and execution statistics are computed for each SQL statement in the STSD.The effects of DDL and DML are considered to produce the execution plan and execution statistics
If there were only one question left ,what would it most probably be?A.What was your childhood dream?B.What is your biggest achievement?C.What is your parents view of you?D.What was your handest expenrience in the war?
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.
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 AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）
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、ownerB、touserC、includeD、schemasE、fromuserF、transformG、remap_schemaH、remap_datafileI、reuse_datafilesJ、remap_tablespace
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 SQLB、 snapshotsC、 SQL Tuning setsD、 index access pathE、 optimizer statisticsF、 materialized view logs
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 AdvisorB、Run the SQL Tuning Advisor (STA)C、Run the Automatic Workload Repository (AWR) reportD、Run the SQL Access Advisor with a hypothetical workload
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 replayB、SQL Tuning AdvisorC、SQL Access AdvisorD、SQL Performance AnalyzerE、Automatic Workload Repository compare reports
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 textB、 the execution planC、 the execution contextD、 the execution frequencyE、 the system change number （SCN）
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.
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.
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 executionB、The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC、The execution plan and execution statistics are computed for each SQL statement in the STSD、The effects of DDL and DML are considered to produce the execution plan and execution statistics
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 SQLB、the execution planC、the execution contextD、the execution frequencyE、the system change number (SCN)
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 serverD、You should recapture the workload to a trace file by using SQL Profiler.
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 collectionB、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
单选题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？（）AownerBtouserCincludeDschemasEfromuserFtransformGremap_schemaHremap_datafileIreuse_datafilesJremap_tablespace
多选题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?（）Athe SQL text SQLBthe execution planCthe execution contextDthe execution frequencyEthe system change number (SCN)
单选题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?（）ARun Segment AdvisorBRun the SQL Tuning Advisor (STA)CRun the Automatic Workload Repository (AWR) reportDRun the SQL Access Advisor with a hypothetical workload
多选题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？ （）ATop SQLBsnapshotsCSQL Tuning setsDindex access pathEoptimizer statisticsFmaterialized view logs
单选题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？（）AYou should recapture the workload by using the data collector.BYou should enable the XP_MSVER stored procedure on the local server.CYou should enable the XP_MSVER stored procedure on the remote serverDYou should recapture the workload to a trace file by using SQL Profiler.
单选题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？（）AYou should create a cached data collectionBYou should create an on-demand non-cached data collection CYou should create a scheduled non-cached data collection DYou should create two different SQL Agent jobs that are scheduled stimultaneously
单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）A Memory AdvisorB Segment AdvisorC SQL Access AdvisorD Automatic Workload Repository （AWR）E Automatic Database Diagnostic Monitor （ADDM）
单选题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（）AApply fine-grained auditing.BImplement value-based auditing.CImpose standard database auditing to auditobject privileges.DImpose standard databaseauditing to audit SQL statements.
单选题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?（）ACreate 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.BRun the Automatic Workload Repository Monitor (ADDM).CCreate 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.DCreate an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
多选题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？（）AEvery SQL statement in the STS is considered only once for execution.BThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.CThe execution plan and execution statistics are computed for each SQL statement in the STS.DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.