Which three table transformations can be done using online redefinition of tables?
(Choose three.)
A. Delete rows
B. Drop a column
C. Change a heap table to an index-organized table
D. Change the data type of a column from LONG to BLOB
E. Change a range-partitioned table to a list-partitioned table
Answer: B, C, E
Explanation:
You can drop a non-primary key column, change a heap table to an index-organized table and vice versa or change a partitioning method for the table online.
Incorrect Answers
A: Rows deleting is a DML operation. It’s not a table transformation.
D: It’s not possible to redefine the table online with a LONG column.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 74-83
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 46-53
Chapter 2: Oracle9i Architecture Changes
No comments:
Post a Comment