Which two events happen? (Choose two.)

An AFTER SUSPEND system event trigger containing no exception handler is fired, and runs out of space after inserting some audit records.Which two events happen? (Choose two.) A.The trigger is aborted B.The trigger is recursively fired C.The original operation (the one that fired the trigger) continues D.The original operation (the one that fired the trigger) […]

Read More

Which three plan directive parameters are used to control this feature? (choose three)

Automatic Consumer Group Switching is an important new feature of the Database Resource Manager.Which three plan directive parameters are used to control this feature? (choose three) A.SWITCH_TIME B.SWITCH_GROUP C.MAX_SESS_POOL D.SWITCH_ESTIMATE Explanation:The SWITCH_CONSUMMER_GROUP_FOR_SESS causes the specified session to immediately be moved into the specified resource consumer group. In effect, this statement can raise or lower priority.SWITCH_GROUP […]

Read More

Which task would be accomplished by the command?

Consider the following configuration: /devices/D1 is a member of disk group dgroupA . /devices/D2 is a member of disk group dgroupA . /devices/D3 is a member of disk group dgroupA . You plan to add a new disk, /devices/D4, to the disk group dgroupA and execute the following command: SQL> ALTER DISKGROUP dgroupA ADD DISK […]

Read More

Which SGA parameter(s) would you modify?

You set SGA parameters in your database as: DB_CACHE_SIZE =24 MB JAVA_POOL_SIZE =48 MB SHARED_POOL_SIZE =96 MB You plan to upgrade to Oracle Database 10 g . You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify? A.change DB_CACHE_SIZE to 44 MB […]

Read More

Which task would be accomplished by the command ?

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 tdgroupAADD ALIAS ‘+tdgroupA/data/datafile.dbf’FOR ‘+tdgroupA.231.45678’; Which task would be accomplished by the command ? A.The command drops the file +tdgroupA.231.45678 B.The command […]

Read More

you need to change to achieve your objective?

You want to unload data from the ORDERS, ORDER_ITEMS, and PRODUCTS database tables to four os flat files by using the External Table Population methods. To achieve this objective, you execute the following command: Create TABLE orders_ext(order_id, order_date, product_id, product_name,quantity)ORGANIZATION EXTERNAL(TYPE ORACLE_DATAPUMPDEFAULT DIRECTORY ext_dirLOCATION (‘orders1.dmp’,’orders2.dmp’,’orders3.dmp’,’orders4.dmp’))PARALLELASSELECTo.order_id,o.order_date,p.product_id,p.product_name,i.quanityFROM orders o,products p,order_items iWHERE o.order_id = i.order_id and i.product_id = […]

Read More

What would you do?

At 6:00 p.m. you notice that the database performance was slow between 2:00 p.m. and 6:00 p.m. due to a series of interrelated problems. You plan to use the Automatic Database Diagnostic Monitor (ADDM) findings for the time period 2:00 p.m. to 6:00 p.m. to resolve the performance issue. The Automatic Workload Repository (AWR) snapshots […]

Read More