READ Free Dumps For Oracle- 1z0-050
| Question ID 6077 | Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) |
| Option A | The database files are corrupted when the database is open |
| Option B | The archived log files are missing for which backup is not available. |
| Option C | The user has dropped an important table that needs to be recovered. |
| Option D | You are not able to start up the database instance because the required database files are missing. |
| Correct Answer | A,D |
| Question ID 6078 | The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAMEJDX index on the ENAME column.You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.What action is required for the dependent objects when you perform online redefinition on the table? |
| Option A | The materialized view should have a fast refresh performed after the online table redefinition is completed. |
| Option B | `The materialized view should have a complete refresh performed after the online table redefinition is completed. |
| Option C | The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete. |
| Option D | The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete. |
| Correct Answer | B |