Exam information

Exam 1Z0-040 - Oracle Database 10g: New Features for Administrators

Other

Which SGA parameter(s) would you modify?


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) […]

Which two events happen?

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.)

Which three plan directive parameters are used to control this feature?

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 Oracle-supplied package is used by Data Pump Export and Import worker processes to load and unload metadata information?

Which SGA parameter(s) would you modify?

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?

What does the Character Set Scanner command line utility do?

Which command meets these two criteria?

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.

Which statement caused this error to be returned when you issued the query?

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?

What are three characteristics of the Data Guard Broker?

What are three characteristics of the Data Guard Broker? (Choose three.)

Which three parameters are ignored when creating an automatic space management segment?

Which three parameters are ignored when creating an automatic space management segment? (Choose three.)



Page 1 of 2012345...1020...Last »