单项选择题

A. SYSTEM tablespaceB. SYSAUX tablespaceC. Undo tablesp……

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.

单项选择题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