READ Free Dumps For Oracle- 1z0-062
| Question ID 2477 | Which two are prerequisites for performing a flashback transaction? |
| Option A | A. Flashback Database must be enabled. |
| Option B | B. Undo retention guarantee for the database must be configured. |
| Option C | C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction. |
| Option D | D. Supplemental logging must be enabled. |
| Option E | E. Recycle bin must be enabled for the database. |
| Option F | F. Block change tracking must be enabled tor the database. |
| Correct Answer | A,C |
| Question ID 2478 | 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 |