搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

You find this query being used in your Oracle 12c database:<br /> Which method a used by the optimizer to limit the rows being returned?（）

A、A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

B、All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

C、A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

D、A TOP-N query is created to limit the rows to 20 percent of the total rows

查看正确答案
更多“ You find this query being used in your Oracle 12c database:<br /> Which method a used by the optimizer to limit the rows being returned?（）”相关的问题
第1题
[单选题] You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?（）

A、A  B、B  C、C  D、D  

点击查看答案
第2题
[单选题] You want a record of all queries that are not using indexes. How would you achieve this?（）

A、By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically  B、By enabling the Error Log because not using indexes is an error  C、By enabling the Slow Query Log and using the – log-queries-not-using-indexes option  D、By enabling the Error Log and using the – log-queries-not-using-indexes option  

点击查看答案
第3题
[] Which three tasks can be performed by using the performance Schema?（）

A、A.Finding queries that are not using indexes  B、B.Finding rows that are locked by InnoDB  C、C.Finding client connection attributes  D、D.Finding the part of a code in which a single query is spending time  E、E.Finding the size of each table  

点击查看答案
第4题
[单选题] You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）

A、enable index monitoring and query the DBA_OBJECTS view  B、enable index monitoring and query the DBA_INDEXES view  C、enable index monitoring and query the V$OBJECT_USAGE view  D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view  

点击查看答案
第5题
[单选题] You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（） 

A、enable index monitoring and query the DBA_OBJECTS view  B、enable index monitoring and query the DBA_INDEXES view  C、enable index monitoring and query the V$OBJECT_USAGE view  D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view  

点击查看答案
第6题
[] Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）

A、A.You can find information about only active transactions from the view  B、B.You can find information about read only transactions from the view  C、C.You require the SELECT ANY TRANSACTION system privilege to access the view   D、D.You can find information about both active and committed transactions from the view   E、E.You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view  

点击查看答案
第7题
[单选题] You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）  

A、 Flashback Table  B、 Flashback Query  C、Flashback Version Query  D、 Flashback Transaction Query  

点击查看答案
第8题
[单选题] This lovely old town has a（）you couldn't find in a big city.

A、condition  B、standard  C、situation  D、charm  

点击查看答案
第9题
[] A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（） A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）

A、A. Execute the query and view Active Session History (ASH) for information about the query.  B、B. Enable SQL trace for the query.  C、C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.  D、D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.  

点击查看答案
第10题
[单选题] In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）

A、 REBUILD  B、 CASCADE  C、 TRUNCATE  D、 ROW MOVEMENT  E、 SHRINK SPACE COMPACT  F、 SHRINK SPACE CASCADE  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服