266 278 chapter 5 language enhancements oracle 9i new

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2 digits. D: It is not 22 digits. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 266-278 Chapter 5: Language Enhancements Oracle 9i New Features, Robert Freeman, p. 139-146 Chapter 5: Miscellaneous Oracle9i Features and Enhancements QUESTION 61: 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 Actualtests.com - The Power of Knowing 1Z0-030 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 QUESTION 62: Examine the statement: ALTER TABLE sales EXCHANGE PARTITION q1_2000 WITH TABLE sales q1_2000 UPDATE GLOBAL INDEXES PARALLEL (DEGREE 4); What is the result of the statement? A. All valid global indexes on the SALES table will retain their USABLE status after the statement completes. B. Nonpartitioned indexes on the SALES table will be marked UNUSABLE, while valid partitioned global and local indexes will retain their USABLE status. C. Valid indexes on the exchanged table SALES _Q1_2000 will remain in the USABLE state, while all indexes associated with the new partition Q12000, will be marked UNUSABLE, including any global indexes on SALES. D. Global indexes on the SALES table will be maintained concurrently with the exchange operation if the statement executes with the desired degree of parallelism (four) otherwise it will execute serially and mark the global indexes UNUSABLE. Answer: A Explanation: Oracle9i overcomes the problem of rebuilding the global index by giving you the option to update global indexes as Oracle performs the partition DDL. This feature is not applicable to local indexes, domain indexes, index-organized tables (IOTs), or to indexes Actualtests.com - The Power of Knowing 1Z0-030 that were UNUSABLE prior to start of the partition DML. You can invoke this capability by using the optional clause UPDATE GLOBAL INDEX of the ALTER TABLE command. You can use this clause with the ADD, COALESCE, DROP, EXCHANGE, MERGE, MOVE, SPLIT, and TRUNCATE partition DDL commands. Incorrect Answers B: Nonpartitioned indexes on the SALES table will not be marked UNUSABLE. C:...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online