Ocp oracle9i database new features for administrators

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: ogram not only based on application usage, but based on data distribution also. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 220-222 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 180-181 Chapter 6: Oracle9i SQL, PL/SQL New Features QUESTION 48: Consider this RMAN command: RMAN> CONFIGURE RETENTION POLICY CLEAR; What is the effect of this command? A. Backups will never expire. B. It removes any retention policy. C. The DELETE OBSOLETE command will fail with an error. D. It sets the retention policy to the default of REDUNDANCY 1. Actualtests.com - The Power of Knowing 1Z0-030 Answer: D Explanation: This command sets retention policy to the default of REDUNDANCY 1. Incorrect Answers A: This command does not mean that backup will never expire. B: It sets the retention policy to the default of REDUNDANCY 1, does not remove any retention policy. C: The DELETE OBSOLETE command will not fail after that command. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 182-189 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 79-84 Chapter 3: New Oracle9i Availability and Recoverability Features QUESTION 49: Examine the statement: DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement? A. The contents and data files belonging to the IND2 tablespace are dropped. B. The statement will only succeed if the IND2 tablespace was built using OracleManaged Files (OMF) data files. C. The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle-Managed Files (OMF) or if the database was created using OMF. D. The contents of the tablespace are dropped along with all its data files except those identified with the Oracle-Managed Files (OMF) naming convention. Answer: A Explanation: After executing this statement the content and data files belonging to the IND2 tablespace will be dropped. Incorrect Answers B: The statement will only succeed in any case if the tablespace is offline. There is no requirement that IND2 tablespace had to be built using Oracle-Managed Files (OMF) data files. C: The statement will only succeed in any case if the tablespace is offline. There is no requirement that IND2 tablespace had to be built using Oracle-Managed Files (OMF) data files or the database was created using OMF. D: The contents of the tablespace are dropped along with all its data files. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-158 Chapter 3: Manageability Enhancements Actualtests.com - The Power of Knowing 1Z0-030 Oracle 9i New Features, Robert Freeman, p. 2-12 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 50: Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic segment-space managed objects? (Choose three) A. It readily responds to dynamic changes for concurrent access. B....
View Full Document

Ask a homework question - tutors are online