1Z0-032
单选题The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）A ALTER TABLE employees monitor index employee_idx_fk; B ALTER INDEX
题目
ALTER TABLE employees monitor index employee_idx_fk;
ALTER INDEX employee_idx_fk monitoring on;
ALTER TABLE employees monitor all indexes;
ALTER INDEX employee_idx_fk monitoring usage;
相似问题和答案
第1题：
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?（）
A. The index remains invisible.
B. The index is not updated by the DML statements on the indexed table.
C. The index automatically becomes visible in order to have it updated by DML on the table.
D. The index becomes unusable but the table is updated by the DML.
E. The index is updated by the DML on the table.
第2题：
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）
- A、Oracle Data Pump.
- B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
- C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
- D、Online Table Redefinition.
- E、Edition-Based Table Redefinition.
正确答案:D
第3题：
（32）下列 SQL 的数据定义语句组中，（ ）包含了不正确的数据定义语句。
Ⅰ．CREATE TABLE? CREATE VIEW? CREATE INDEX?
Ⅱ．DROP TABLE? DROP VIEW? DROP INDEX?
Ⅲ．ALTER TABLE? ALTER VIEW? ALTER INDEX?
A）仅Ⅰ
B）仅Ⅱ
C）仅Ⅲ
D）都包含
（32）【答案】C)
【解析】由SQL中数据定义语句的格式可知，III中的ALTER VIEW…应为UPDATE VIEW
第4题：
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command： SQL>CREATE INDEX ord_custname_ix ON orders（custname）； The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test. Which is the most efficient method of performing this task？（）
- A、 disabling the index
- B、 making the index invisible
- C、 making the index unusable
- D、 using the MONITORING USAGE clause for the index
正确答案:B
第5题：
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
- A、ALTER TABLE SPLIT PARTITION
- B、ALTER TABLE MERGE PARTITION
- C、ALTER TABLE TRUNCATE PARTITION
- D、ALTER TABLE ADD PARTITION
- E、ALTER TABLE DROP PARTITION
- F、ALTER TABLE MOVE PARTITION
正确答案:C,E
第6题：
A. ALTER TABLE SPLIT PARTITION
B. ALTER TABLE MERGE PARTITION
C. ALTER TABLE TRUNCATE PARTITION
D. ALTER TABLE ADD PARTITION
E. ALTER TABLE DROP PARTITION
F. ALTER TABLE MOVE PARTITION
第7题：
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）
- A、 Index-organized table
- B、 Mapping Table
- C、 Clustered Table
- D、 Journal Table
正确答案:D
第8题：
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:SQL>CREATE INDEX ord_custname_ix ON orders(custname);The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）
A. disabling the index
B. making the index invisible
C. making the index unusable
D. using the MONITORING USAGE clause for the index
第9题：
You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）
- A、 Rebuild the index.
- B、 Coalesce the index.
- C、 Drop and re-create the index in the new tablespace.
- D、 Relocate the index using the ALTER INDEX...MOVE statement.
正确答案:A
第10题：
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
正确答案:C