You set SGA parameters in your database as: DB_CACHE_SIZE =24 MB JAVA_POOL_SIZE =48 MB SHARED_POOL_SIZE =96 MB You plan to upgrade to Oracle Database 10 g . You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify?
An AFTER SUSPEND system event trigger containing no exception handler is fired, and runs out of space after inserting some audit records.
Which two events happen? (Choose two.)
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)
Which Oracle-supplied package is used by Data Pump Export and Import worker processes to load and unload metadata information?
What does the Character Set Scanner command line utility do?
Which command meets these two criteria?
1 Runs the backup at full speed
2 Either finishes the task in the allotted time, or terminates Recovery Manager (RMAN) with an error if it fails to finish the task in the allotted time.
A query on the sales table returned the following error:
Tue May 11 07:05:40 2004
Some indexes or index [sub]partitions of table
SCOTT. SALES have been marked unusable.
Which statement caused this error to be returned when you issued the query?
You set SGA parameters in your database as:
You plan to upgrade to Oracle Database 10g. You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata.
Which SGA parameter(s) would you modify?
What are three characteristics of the Data Guard Broker? (Choose three.)
Which three parameters are ignored when creating an automatic space management segment? (Choose three.)