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.
A: The size of a granule is 4 MB if the SGA at startup is less than 128 MB; it will be 16
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
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
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.
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
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 168-176
Chapter 3: Manageability Enhancements Actualtests.com - The Power of Knowing 1Z0-030
Automatic Consumer Group Switching is an important new feature of the Database
Which three plan directive parameters are used to control this feature? (Choose
Answer: A, B, D
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
- Fall '09
- Oracle Database, Database management system, new features, Oracle9i, OCP Oracle9i Database