You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）

单项选择题You issued the following command：   ALTER TABLE SCOTT.EMP SHRINK SPACE；   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties：   DATA1 is a read write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error：   ORA-10635： Invalid segment or tablespace type    What could be the reason for the failure of the command？（）

A. The tablespace， DATA1， is not read-only.
B. The tablespace， DATA1， is not autoextensible.
C. The tablespace， DATA1， is not offline.
D. The segment space management for the tablespace， DATA1， is manual.

单项选择题YouareperformingtheshrinkoperationontheSCOTT.EMPtable.YouwanttoperformthesameoperationonalldependentobjectsoftheSCOTT.EMPtable.WhatisNOTaprerequisitefortheoperation？（）

A. You must enable the row movement on the SCOTT.EMP table.
B. You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
C. You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
D. You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

单项选择题You executed the following code：   SQL> CREATE 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；   In which tablespace will the mapping table be created？（）

A. SYSTEM tablespace
B. SYSAUX tablespace
C. Undo tablespace
D. The tablespace of the Index Organized Table （IOT）

单项选择题You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

A.The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
B. The command will not execute successfully because resumable space allocation is enabled at the session level.
C. The command will execute successfully and resumable space will be allocated at the session level.
D. The command will execute successfully and resumable space will be allocated at the instance level.

单项选择题YouareaDBAofyourcompany.YoucreatedadatabasenamedSALESonanOracle10ginstance.YouhavedefinedanindexnamedINDEX1onthedatabasetablenamedINVENTORY.UsersarecomplainingthatqueriesaccessingtheINVENTORYtablearerunningslow.UponinvestigationyoudeterminethatthetablespacewheretheindexislocatedisexperiencinghighI Oandyoudecidetorelocatetheindextoanothertablespace.Whichofthesewillbethebestwaytoaccomplishthisobjective？（）

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.