Which three table transformations can be done by using online redefinition of tables? (Choose three.)
A. Delete rows
B. Rename 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 the data type of a column from DATE to CHAR
Answer: B, C, E
Explanation:
You can add or rename columns, change a heap table to an index-organized table and change the data type of a column from DATE to CHAR by using online redefinition of tables.
Incorrect Answers
A: Rows deleting is DML operation. It’s not a table transformation operation.
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