Tag «Exam 1Z0-040 (v.1)»

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 …

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 …

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 …

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 …

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 …

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.: …

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 …

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 …