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 six files are maintained in the Flash Recovery Area? (Choose six.)
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?
You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?
You enabled block change tracking for faster incremental backups in your database.Which background process writes to the change tracking file?
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.)
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?
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?
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 […]