If you do not set sgamaxsize or if you set it to 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: you do not set SGA_MAX_SIZE or if you set it to a value less than initial SGA size, you cannot increase the SGA size later. Incorrect Answers A: The size of a granule is 4 MB if the SGA at startup is less than 128 MB; it will be 16 MB otherwise. D: The size of the SGA components is not set by the SGA_MAX_SIZE parameter. They are only limited by SGA_MAX_SIZE value. As a DBA, you can dynamically change the value of the parameters DB_CACHE_SIZE, SHARED_POOL_SIZE, and LARGE_POOL_SIZE up to the size of SGA_MAX_SIZE. 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 6: What is true about version-enabled tables? A. The unit of versioning is the schema. B. It is possible to version enable a table pertaining to SYS. C. There are as many segments as versions for the same base table. D. It is possible to create workspaces if there is no version-enabled table in the database. Answer: D Explanation: A workspace is a virtual database facility that enables you to maintain multiple versions of one row of data and it enables each workspace context to reference a different version of this row as compared to another workspace context. It's possible to create workspace if there is no version-enabled table in the database. Incorrect Answers A: The unit of versioning is the table, not the schema. B: It is not possible to version enable a table in SYS schema. C: This statement about the same amount of segments as versions for the same base table is incorrect. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 168-176 Chapter 3: Manageability Enhancements Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 7: Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature? (Choose three.) A. SWITCH_TIME B. SWITCH_GROUP C. MAX_SESS_POOL D. SWITCH_ESTIMATE Answer: A, B, D Explanation: You can specify the maximum estimated time to complete (in seconds) for an operation by assigning a value the MAX_EST_EXEC_TIME parameter; the default value for this parameter is UNLIMITED. Oracle will estimate the time the operation with table will take. It the SWITH_ESTIMATE parameter is set to TRUE, and if Oracle's estimate is greater than the value specified by MAX_EST_EXEC_TIME, Oracle will return an error and the operation will not be started. If the SWITCH_ESTIMATE parameter is FALSE, Oracle will start the operation even if Oracle's estimate is greater than the value specified by MAX_EST_EXEC_TIME; Oracle will only switch groups based on other criteria being met. The SWITCH_GROUP parameter specifies the group to which the session will be switched. The SWITCH_TIME parameter specifies the amount of time a session can execute before it must be switched to another group. The...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online