You can use also the configure command to establish a

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: Knowing 1Z0-030 restore, and recover parameters that persistent across RMAN sessions. You can use also the CONFIGURE command to establish a persistent number of channel settings. You can configure the channel information to specify the target device type, which is the target location for backups. Incorrect Answers B: It does not "remember" the last backup command. You can just use the CONFIGUTE command to achieve automatic configuration. C: It does not enable you to store your Channel attribute settings in the Recovery Catalog with each script. 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 109: What do you need to do in order for the Database Resource Manager to estimate, in advance, the execution time of a statement? A. Set the TIMED_STATISTICS initialization parameter B. Gather optimizer statistics on related objects. C. Set the TIMED_OS_STATISTICS initialization parameter. D. Nothing Answer: B Explanation: The Database Resource Manager can estimate, in advance, the execution time of a statement gathering optimizer statistics on related objects. Incorrect Answers A: Setting the TIMED_STATISTICS initialization parameter will not help the Database Resource Manager to estimate the execution time of a statement. TIMED_STATISTICS specifies whether or not statistics related to time are collected. C: Setting the TIMED_OS_STATISTICS initialization parameter will not help the Database Resource Manager to estimate the execution time of a statement. TIMED_OS_STATISTICS specifies the interval (in seconds) at which Oracle collects operating system statistics when a request is made from the client to the server or when a request completes. D: It is required to gather optimizer statistics on related objects to achieve this. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 122-129 Chapter 3: Manageability Enhancements QUESTION 110: You need to version enable the MORTGAGE table containing customer mortgage trend information. Which syntax version enables the MORTGAGE table? Actualtests.com - The Power of Knowing 1Z0-030 A. DBMS_LT.ENABLETABLE('MORTGAGE'); B. DBMS_WM.ENABLE_TABLE('MORTGAGE'); C. DBMS_LT.ENABLEVERSIONING('MORTGAGE'); D. DBMS_WM.ENABLEVERSIONING('MORTGAGE'); Answer: D Explanation: The ENABLEVERSIONING procedure of the DBMS_WM package will version enable the MORTGAGE table. Incorrect Answers A: This syntax is incorrect to version enable the MORTGAGE table. There is no DBMS_LT package in Oracle. B: This syntax is incorrect to version enable the MORTGAGE table. C: This syntax is incorrect to version enable the MORTGAGE table. There is no DBMS_LT package in Oracle. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 166-176 Chapter 3: Manageability Enhancements QUESTION 111: During scheduled maintenance for a database that runs 24 hours a day, 7 days a week, the DBA wants t...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online