|
|
Oracle 1z0-040: Oracle Database 10g: New Features for Administrators
|
#1. Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.)
|
|
#2. Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?
|
|
#3. Which six files are maintained in the Flash Recovery Area? (Choose six.)
|
|
#4. Consider the following scenario:
You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command: ALTER DISKGROUP tdgroupA ADD ALIAS ‘+tdgroupA/data/datafile.dbf’ FOR ‘+tdgroupA.231.45678’;
Which task would be accomplished by the command?
|
|
#5. Exhibit
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?
|
|
#6. You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?
|
|
#7. You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?
|
|
#8. 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.)
|
|
#9. 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?
|
|
#10. The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?
|
|
|
|
 gen. 0.125
|
Server date 12:09 14-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
1z0-040 certification
1z0-040 master dump