单选题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？（）AYou must enable the block change tracking feature.BYou must have enable the flashba

题目

单选题

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？（）

You must enable the block change tracking feature.

You must have enable the flashback feature.

You must use the OMF in your database.

You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the above statement?()

A.A syntax error will result as you cannot specify more than one partition in the same statement

B.All data in p1 and p3 partitions are removed and the table definition is changed

C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged

D.Only the first partition (p1) will be dropped as only one can be dropped at any time

参考答案：B

第2题：

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）

A、ALTER TABLE commercials MODIFY (description CHAR2(1000));
B、ALTER TABLE commercials CHANGE (description CHAR2(1000));
C、ALTER TABLE commercials CHANGE (description VARCHAR2(1000));
D、ALTER TABLE commercials MODIFY (description VARCHAR2(1000));
E、You cannot increase the size of a column if the table has rows.

正确答案:D

第3题：

View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）

A. An error is produced.

B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

参考答案：B

第4题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

A、Immediately following statement execution
B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued
C、After the ALTER TABLE SET UNUSED COLUMN command is issued
D、After the ALTER TABLE MODIFY command is issued

正确答案:B

第5题：

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.

正确答案:D

第6题：

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()

A. ALTER TABLE SPLIT PARTITION

B. ALTER TABLE MERGE PARTITION

C. ALTER TABLE TRUNCATE PARTITION

D. ALTER TABLE ADD PARTITION

E. ALTER TABLE DROP PARTITION

F. ALTER TABLE MOVE PARTITION

参考答案：C, E

第7题：

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL> DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）

A、 the datafiles associated with the SYSTEM tablespace
B、 the datafiles associated to the DATA1 tablespace
C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
D、 all the datafiles in the database

正确答案:D

第8题：

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()

A. ALTER TABLE students ADD PRIMARY KEY _ id;

B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

参考答案：D

第9题：

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

A、ALTER TABLE SPLIT PARTITION
B、ALTER TABLE MERGE PARTITION
C、ALTER TABLE TRUNCATE PARTITION
D、ALTER TABLE ADD PARTITION
E、ALTER TABLE DROP PARTITION
F、ALTER TABLE MOVE PARTITION

正确答案:C,E

第10题：

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

A、UPDATE TABLE
B、CREATE CLUSTER
C、TRUNCATE TABLE
D、ALTER TABLE MOVE
E、INSERT INTO···VALUES
F、ALTER TABLE···DROP COLUMN
G、ALTER TABLE···DROP PARTITION

正确答案:A,E

You are shrinking the SCOTT.EMP table by executing the ALTER

题目

相似问题和答案

更多相关问题

相关内容