To assist you in migrating your existing LONG columns to LOB data types, the ALTER TABLE syntax has been enhanced to support LONG to CLOB migration and LONG RAW to BLOB migration.
During this migration, if redo logging is enabled for the table or for the LOB being created, the ALTER TABLE ... MODIFY command temporarily _______ the space requirements.
A. Halves
B. Doubles
C. Triples
D. Quadruples
Answer: B
Explanation:
The ALTER TABLE ... MODIFY command temporarily doubles the space requirements to support LONG to CLOB or LONG RAW to BLOB migration. It happened because of need to keep temporary converted data.
Incorrect Answers
A: It doubles the space requirements, not halves them.
C: The ALTER TABLE ... MODIFY command temporarily doubles, not triples, the space requirements to support LONG to CLOB or LONG RAW to BLOB migration.
D: It doubles the space requirements, not quadruples them.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 262-263
Chapter 5: Language Enhancements
Oracle 9i New Features, Robert Freeman, p. 147
Chapter 5: Miscellaneous Oracle9i Features and Enhancements
No comments:
Post a Comment