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.)
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 REDUNDANCY
FAILOVERGROUP control01 DISK
FAILOVERGROUP control02 DISK
The disk “/devices/A1” is currently a member disk of a disk group by name “tdgroup1”
Which task would be accomplished by the command?