The default for the switchgroup parameter is null 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: default for the SWITCH_GROUP parameter is NULL; the default for the SWITCH_TIME parameter is UNLIMITED. Incorrect Answers C: There is no MAX_SESS_POOL directive parameter in Oracle. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 122-129 Chapter 3: Manageability Enhancements QUESTION 8: You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback? (Choose two.) A. Oracle Flashback uses undo information to construct consistent data. B. You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C. You can only use an Oracle Flashback view of the data if the required records are still in the online redo log files. D. Oracle Flashback lists the DML that was executed during the period you identify when initiating your session Actualtests.com - The Power of Knowing 1Z0-030 Answer: A, B Explanation: To perform DML operations while using an Oracle Flashback image you can use a cursor. Oracle Flashback uses undo information to construct consistent data. The UNDO_RETENTION parameter must be set and the UNDO tablespace must be large enough so that undo generated during the period we want to query will not be overwritten. Incorrect Answers C: You can use an Oracle Flashback view of the data if the required records are in the online redo log files or there is information in the UNDO tablespace about required records. D: Oracle Flashback does not list the DML that was executed during the period you identify when initiating your session. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 45-47 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 64-68 Chapter 3: New Oracle9i Availability and Recoverability Features QUESTION 9: If you create your database using Oracle Managed Files (OMF), what is true? A. You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B. You must define directories for two online redo log groups and three copies of the control file. C. If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D. You must use only OMF data files when adding new tablespaces or data files to your database in the future. Answer: D Explanation: If you created your database using Oracle Managed Files (OMF), you must use only OMF data files when adding new tablespaces or data files to your database in the future. Incorrect Answers A: You don't need to use Oracle predefined names to identify raw partitions that will hold OMF structures. B: You should define directories for OMF datafiles, redo log files and control files. Oracle9i gives you two new initialization parameters, DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n, to specify the location where Oracle will create and manage OMFs; n can take a value from 1 to 5. So there is no limitation on control files amount to 3 copies. C: If...
View Full Document

Ask a homework question - tutors are online