READ Free Dumps For Oracle- 1z0-050
| Question ID 6015 | You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition? |
| Option A | The materialized log should be dropped before the online table redefinition process. |
| Option B | Triggers with the PRECEDES clause should be disabled before the online table redefinition process. |
| Option C | Referential integrity constraints must be manually enabled after the online table redefinition process. |
| Option D | The dependent materialized view should have a complete refresh performed after the online table redefinition process. |
| Correct Answer | D |
| Question ID 6016 | Examine the following values of the Initialization parameters In the database having the SID ORCL: BACKGROUNDJDUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/ u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01 /app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home? |
| Option A | /u01/app/oracle |
| Option B | $ORACLE_HOME/log |
| Option C | $ORACLE_HOME/bdump |
| Option D | /u01/app/oracle/product/11.1.0/db_1 |
| Correct Answer | A |