Exam information

Exam 1Z0-040 - Oracle Database 10g: New Features for Administrators (Jan 9, 2013)

Other

Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.)


Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.)

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

Which six files are maintained in the Flash Recovery Area? (Choose six.)

Which six files are maintained in the Flash Recovery Area? (Choose six.)

What would you do?

One the evening of April 22, you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that was dropped from the database at 8:00 a.m. No full backup has been taken after April 15.What would you do?

What could be the reason?

You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?


Which background process writes to the change tracking file?

You enabled block change tracking for faster incremental backups in your database.Which background process writes to the change tracking file?

Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)

You want to enforce a company’s business policy on several objects by using a single policy function.Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)

You need to ensure that the ADDM analysis is run over a time span of two hours in future.

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database if facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future.What would you do?

What would be the first step to configure Flashback Database?

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?

Which task would be accomplished by the command?

Consider the following command to add a new disk group called "tdgroupA" with two failover groups:CREATE DISKGROUP tdgrouopA NORMAD REDUNDANCYFAILOVERGROUP control01 DISK’/devices/A1′,’/devices/A2′,’/devices/A3’FAILOVERGROUP control02 DISK’/devices/B1′,’/devices/B2′,’/devices/B3′;The […]



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