|
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: 1: Rows deleting is DML operation. It’s not a table transformation operation. 4: It’s not possible to redefine the table online with a LONG column. Reference: 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
|