單項(xiàng)選擇題

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

你可能感興趣的試題

多項(xiàng)選擇題

Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1：
ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES
While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available.
Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

A.drop and re-create the index
B.coalesce the ORDERS_IND index
C.coalesce the INDEXES tablespace
D.drop and re-create the ORDERS table
E.rebuild the index online and move it to another tablespace

單項(xiàng)選擇題

In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.
What is the best table structure that you can use to gain optimal performance？（）

A.heap table
B.object table
C.external table
D.clustered table
E.global temporary table
F.index-organized table （IOT）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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？（）

你可能感興趣的試題

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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