C if your create database command fails any omf

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: your CREATE DATABASE command fails, any OMF database files that have Actualtests.com - The Power of Knowing 1Z0-030 already been created will not be dropped automatically. This feature will work for the OMF datafiles only after successful database creation. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 2-12 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 10: What is true regarding a transaction executed in Automatic Undo Management mode? A. It is possible for the transaction to span different undo segments. B. It is possible for the transaction to reuse inactive extents from another undo segment. C. It is possible for the transaction to use inactive extents from another undo tablespace. D. It is possible for the transaction to extend the undo tablespace, even if defined with AUTOEXTENSIBLE set to FALSE. Answer: B Explanation: It is possible for the transaction to reuse inactive extents from another undo segment in Automatic Undo Management mode. Incorrect Answers A: It is not possible for the transaction to span different undo segments. It can be assign only to the one undo segments. C: It is not possible for the transaction to use inactive extents from another undo tablespace. It can only REUSE inactive extents from another undo segment, not from another undo tablespace. D: It's not possible for the transaction to extend the undo tablespace, if defined with AUTOEXTENSIBLE set to FALSE. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-166 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 53-54 Chapter 2: Oracle9i Architecture Changes QUESTION 11: Which two are true regarding external tables? (Choose two.) A. External tables can be updated. B. External tables are read-only tables. C. Indexes can be created on external tables. D. Indexes cannot be created on external tables. Actualtests.com - The Power of Knowing 1Z0-030 Answer: B, D Explanation: External tables are read-only tables whose data resides in an external OS flat file, and whose definition is stored inside the database. Indexes cannot be created on external tables. Incorrect Answers A: External tables cannot be updated. They are read-only tables. C: Indexes cannot be created on external tables. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 131-134 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 111-116 Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features QUESTION 12: When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view? A. During a query's parse time only B. During a query's execution time only C. During any kind of DML statement execution D. During the execution of an INSERT statement only Answer: A Explanation: During a query's parse time Oracle9i flags an index as being used in the V$OBJECT_USAGE view. You can q...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online