AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-062





Question ID 2479

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:
 
There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
 
 

Option A

A.    Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
 

Option B

B.    Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
 

Option C

C.    The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
 

Option D

D.    ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
 

Option E

E.    Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
 

Correct Answer B
Explanation


Question ID 2480

On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?
 

Option A

A.    Both the indexes are created; however, only the ORD_COSTOMER index is visible.
 

Option B

B.    The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
 

Option C

C.    Only the ORD_CUSTOMER_IX1 index is created.
 

Option D

D.    Only the ORD_CUSTOMER_IX2 index is created.
 

Option E


E.    Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
 

Correct Answer A,E
Explanation

Send email to admin@getfreedumps for new dumps request!!!