单项选择题
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?()
单项选择题 You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
单项选择题 YouareaDBAofyourcompany.YoucreatedadatabasenamedSALESonanOracle10ginstance.YouhavedefinedanindexnamedINDEX1onthedatabasetablenamedINVENTORY.UsersarecomplainingthatqueriesaccessingtheINVENTORYtablearerunningslow.UponinvestigationyoudeterminethatthetablespacewheretheindexislocatedisexperiencinghighI/Oandyoudecidetorelocatetheindextoanothertablespace.Whichofthesewillbethebestwaytoaccomplishthisobjective?()