READ Free Dumps For Oracle- 1z0-050

Question ID 1869	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	A.    The materialized log should be dropped before the online table redefinition process.
Option B	B.    Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
Option C	C.    Referential integrity constraints must be manually enabled after the online table redefinition process.
Option D	D.    The dependent materialized view should have a complete refresh performed after the online table redefinition process.
Correct Answer	D

Explanation

Question ID 1870	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	A.    /u01/app/oracle
Option B	B.    $ORACLE_HOME/log
Option C	C.    $ORACLE_HOME/bdump
Option D	D.    /u01/app/oracle/product/11.1.0/db_1
Correct Answer	A

Explanation

Previous-Page 1 2. . . 43 44 45 46 47 48 49. . . 177 178 Next-Page

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