Com the power of knowing 1z0 030 longer need d the

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: ntries. B: It is not used to delete data dictionary information about database objects you no Actualtests.com - The Power of Knowing 1Z0-030 longer need. D: The Metadata Application Programming Interface (API) does not prepare pseudocode modules for conversion to Java or PL/SQL programs. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 136-138 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 44-46 Chapter 2: Oracle9i Architecture Changes QUESTION 85: What should you look at first to compute the number of undo blocks written per second to disk? A. V$UNDOSTAT B. V$ROLLSTAT C. V$TRANSACTION D. DBA_UNDO_EXTENTS E. DBA_ROLLBACK_SEGS Answer: A Explanation: This view displays a histogram of statistical data to show how well the system is working. Each row in the view keeps statistics collected in the instance for a 10-minute interval.You can use this view to estimate the amount of undo space required for the current workload. The database uses this view to tune undo usage in the system. This view is available in both SMU (system managed undo) mode and RBU (rollback segment undo) mode. Incorrect Answers B: This dynamic view contains rollback segment statistics. C: This dynamic view lists the active transactions in the system D: The DBA_UNDO_EXTENTS data dictionary view is used to show information about extents in the UNDO segments. E: The DBA_ROLLBACK_SEGS data dictionary view contains information about rollback segments. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-164 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 24-25 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 86: A bitmap join index is defined as __________. A. An index used to join two bitmap indexes on a table B. A bitmap index created for the join of two or more tables Actualtests.com - The Power of Knowing 1Z0-030 C. A bitmap index created on the join of two or more indexes D. A bitmap index created on the join of two or more indexed-organized tables Answer: B Explanation: Prior to Oracle9i, you could create bitmap indexes on a single table. Bitmap indexes are very useful in data warehousing environment for low-cardinality columns. Oracle9i extents this concept to a bitmap join index that optimizes the joining of two or more tables. A bitmap join index is a space- and performance-efficient technique. By predetermining associations, bitmap join indexes eliminate the large volumes of data generated with Cartesian products performed in a join operation. Incorrect Answers A: A bitmap join index is not a join of two bitmap indexes on a table. C: A bitmap index created on the join of two or more tables, not indexes. D: You cannot reference an IOT or a temporary table. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 142-143 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 54-56 Chapter 2: Oracle9i Architecture Changes QUESTION 8...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online