单项选择题
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.
点击查看答案
相关考题
-
单项选择题
Inwhichscenariowillyoucreateahashcluster？（）
A. when you want the data to be returned automatically in chronological order
B. if the application uses queries joining tables only occasionally
C. if the queries against the clustered table use the equality operator （=） to retrieve the desired row
D. if the full table scan is executed often on only one of the clustered tables -
单项选择题
Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers？（）
A. V$LOG
B. V$LOGFILE
C. DBA_LOG_GROUPS
D. V$LOG_HISTORY -
单项选择题
You executed the following code： SQL> CERATE TABLE COUNTRY （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL， COUNTRY_NAME VARCHAR2（20）， CURRENCY_NAME VARCHAR2（20）， CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID）） ORGANIZATION INDEX； Which types of tables will be created automatically？（）
A. journal table
B. clustered table
C. mapping table
D. partitioned table
