Oracle认证考试
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment
题目
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
- A、The Automatic Memory Manager (AMM)
- B、The SQL Tuning Advisor
- C、The Segment Advisor
- D、The SQL Access Advisor
参考答案和解析
相似问题和答案
第1题：
A senior DBA asked you to execute the following command to improve performance:SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?（）
A. The keep pool is not configured.
B. Automatic Workarea Management is not configured.
C. Automatic Shared Memory Management is not enabled.
D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
第2题：
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
- A、The Automatic Memory Manager (AMM)
- B、The SQL Tuning Advisor
- C、The Segment Advisor
- D、The SQL Access Advisor SQL
正确答案:D
第3题：
A. The Memory Advisor
B. The SQL Tuning Advisor
C. The Undo Advisor
D. The SQL Access Advisor
第4题：
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）
正确答案:C
第5题：
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.
正确答案:D
第6题：
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
第7题：
In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）
- A、export and import the mapping table
- B、drop and recreate the mapping table
- C、truncate the mapping table and reinsert the values
- D、use the ALTER TABLE .. REBUILD command to defragment the mapping table
正确答案:B
第8题：
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above
第9题：
You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）
- A、Memory Advisor
- B、Segment Advisor
- C、SQL Tuning Advisor
- D、SQL Access Advisor
- E、Automatic Database Diagnostic Monitor （ADDM）
正确答案:A
第10题：
While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）
- A、 Memory Advisor
- B、 Segment Advisor
- C、 Undo Advisor
- D、 SQL Tuning Advisor
正确答案:C