单项选择题
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）
A. You must enable the block change tracking feature.
B. You must have enable the flashback feature.
C. You must use the OMF in your database.
D. You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
相关考题
-
单项选择题
YouaremaintainingyourdatabaseinOracle10g.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase，youwanttodeterminethelogfilesizethatshouldequaltheminimumsizeofalltheonlineredologfiles.Whichcolumnwillenableyoutoperformthedesiredtask？（）
A. the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
B. the column of the V$INSTANCE_RECOVERY view
C. the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
D. the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view -
单项选择题
Youarecreatingacluster.Thetablesintheclusterhavearelativelyuniformdistributionofvaluesintheindexcolumnandthequeriesagainsttheclusteredtablewillalmostuseanequalityoperatortoretrievethedesiredrow.Whichtypeofclusterwillyoucreate？（）
A. Index cluster
B. Hash cluster
C. Sorted Hash cluster
D. Real Application Cluster -
单项选择题
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.
