The default value for this parameter is off

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: to gather statistics on the buffer cache by setting the value of the DB_CACHE_ADVICE parameter to ON. The default value for this parameter is OFF. DB_CACHE_ADVICE can take on a third value, READY, which specifies that memory is allocated, but it does not gather statistics. The activity of collecting statistics affects the performance of the system. DB_CACHE_ADVICE is a dynamic parameter and can be changed to ON using ALTER SYSTEM command. Incorrect Answers A: The Advisory is off. B: The Advisory is off. C: The memory for the Advisory remains allocated. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 180-182 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 16-17 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 90: Which four are true regarding the Workspace Manager in Oracle9i? (Choose four.) A. Automatically versions all tables B. Automatically installed with Oracle9i C. Merges changes with parent rows or discards changes D. Provides mechanism to identify and resolve conflicts E. Allows for version enabling tables by use of a packaged procedure Answer: B, C, D, E Explanation: The Workspace Manager in Oracle9i automatically installed with Oracle9i. It merges changes with parent rows or discards changes, provides mechanism to identify and resolve conflicts and allows for version enabling tables by use of a packaged procedure. Incorrect Answers A: It does not automatically versions all tables. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 166-176 Chapter 3: Manageability Enhancements QUESTION 91: Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing the dbms_redefinition_start_redef table procedure call? (Choose two). A. Grant privileges on the interim table B. Invoke the dbms_redefinition.can_redef_table procedure Actualtests.com - The Power of Knowing 1Z0-030 C. Invoke the dbms_redefinition.sync_interim_table procedure D. Create any triggers, indexes, or constraints on the interim table E. Create an empty interim table with all the desired characteristics Answer: B, E Explanation: Before the issuing the dbms_redefinition_start_redef table procedure call it's recommended to invoke the dbms_redefinition.can_redef_table procedure and create an empty interim table with all the desired characteristics. Dbms_redefinition_start_redef procedure verifies that the table can be redefined online. Incorrect Answers A: You don't need to grant privileges on the interim table. C: It is recommended to periodically synchronize the interim table with the source one when a large amount of DML is executed on the table while the re-organization is taking place by calling the dbms_redefinition.sync_interim_table() procedure. But this step is not required. D: You don't need to create any triggers, indexes, or constraints on the interim table. OCP Oracle9i Database: New Features for Administrators, Danie...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online