Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specifi

Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.) A.Enterprise Manager GUI B.DBMS_TRACE package APIs C.DBMS_ADVISOR package APIs D.DBMS_MONITOR package APIs E.$ORACLE_HOME/rdbms/admin/addmrpt.sql script Explanation:To make use of ADDM, a PL/SQL interface called DBMS_ADVISOR has been implemented. This PL/SQL interface may be called […]

Read More

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

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components? A.PMON B.SMON C.MMNL D.MMAN E.MMON Explanation:The Automatic Shared Memory Management feature uses a new background process named Memory Manager (MMAN). MMAN serves as the SGA Memory Broker and coordinates the sizing of the memory components. The SGA Memory Broker […]

Read More

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

Which six files are maintained in the Flash Recovery Area? (Choose six.) A.control file B.RMAN files C.password file D.parameter file E.flashback logs F.data file copies G.core dump files H.archived log files I.RMAN recovery scripts J.control file autobackpus Explanation:The Flash Recovery Area is a unified storage location for all recovery-related files and activities in an Oracle […]

Read More

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? A.recover the database […]

Read More

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? A.None of the SYSAUX occupants can be relocated. B.The USERS tablespace is a bigfile tablespace (BFT). C.The united Job Scheduler occupant cannot be relocated. D.The SYSAUX occupants can be relocated to the […]

Read More

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? A.RBAL B.CKPT C.SMON D.PMON E.MMON F.CTWR G.DBWR Explanation:CTWR : This is a new process Change Tracking Writer (CTWR) which works with the new block changed tracking features in 10g for fast RMAN incremental backups. REF.: […]

Read More

Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure t

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.) A.DBMS_RLS.STATIC B.DBMS_RLS.DYNAMIC C.DBMS_RLS.SHARED_STATIC D.DBMS_RLS.SHARED_DYNAMIC E.DBMS_RLS.CONTEXT_SENSITIVE F.DBMS_RLS.SHARED_CONTEXT_SENSITIVE Explanation:DBMS_RLS. SHARED_STATICThe policy function executes once, Once, then the […]

Read More

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? A.Enable flashback logging. B.Start the database in the ARCHIVELOG mode. C.Issue the ALTER DATABASE FLASHBACK ON; command. D.Set the FAST_START_MTTR_TARGET initialization parameter. Show Answer

Read More

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 disk “/devices/A1” is currently a member disk of a disk group by name “tdgroup1” Which task would be accomplished by the command? A.The command would result in an error […]

Read More