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) […]
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?
Which command meets these two criteria?1 Runs the backup at full speed2 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 2004Some indexes or index [sub]partitions of tableSCOTT. 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:DB_CACHE_SIZE=24MBJAVA_POOL_SIZE=48MBSHARED_POOL_SIZE=96MBYou 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 does the Character Set Scanner command line utility do?
Which statement correctly describes setup of a server-persistent parameter file (SPFILE) when used with Real Application Clusters?
What are three characteristics of the Data Guard Broker? (Choose three.)