black

1z0-043

登录

单项选择题

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?()

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

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064