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: |
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 |
Question ID 2480 | On your Oracle 12c database, you Issue the following commands to create indexes |
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 |
|
Correct Answer | A,E |