Incorrect answers a you can switch undo tablespaces

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: ew transactions will be assigned to the new undo tablespace. Incorrect Answers A: You can switch undo tablespaces while active transactions will run in the old undo tablespace. All new transactions will be assigned to the new undo tablespace. B: Current active transactions will abort if you switched undo tablespaces. C: Current active transactions will continue to execute inside UNDO1 till they commit or roll back. They will not be automatically migrated to UNDO2. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-166 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 19-25 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 46: Examine the list of variables and their data types: Name Data Type TS, TS1 TIMESTAMP TSZ TIMESTAMP WITH TIME ZONE TLZ TIMESTAMP WITH LOCAL TIME ZONE IYM INTERVAL YEAR TO MONTH IDS INTERVAL DAY TO SECOND Which three expressions using the new date and time data types are valid? (Choose three.) A. IDS* 2 B. TS + IYM C. TS -TS1 D. IDS - TS E. IDS + IYM Answer: A, B, E Explanation: IDS*2, TS+IYM and IDS+IYM are valid new date and time data types. Incorrect Answers C: You cannot subtract timestamps. D: It's not possible to subtract timestamp from the interval day to second. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 266-271 Chapter 5: Language Enhancements Oracle 9i New Features, Robert Freeman, p. 132-135 Chapter 5: Miscellaneous Oracle9i Features and Enhancements Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 47: Consider the following statement: SQL> EXECUTE DBMS _STATS.GATHER_SCHEMA_STATS (2> ownname => 'OE', 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 4> method opt => 'for all columns size AUTO'); What is the effect of 'for all columns size AUTO' of the METHOD_OPT option? A. The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. B. The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema. C. The Oracle server creates a histogram based on data distribution and application usage of the column/s for all table, column, and index statistics for the OE schema. D. The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema. Answer: C Explanation: The Oracle server creates a histogram based on data distribution and application usage of the column/s for all table, column, and index statistics for the OE schema. Incorrect Answers A: The Oracle server does not create a new histogram based on existing histogram. B: Histogram creation is not regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema. D: The Oracle server creates a hist...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online