Oracle
1Z0-050 · Question #90
1Z0-050 Question #90: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #90. The question stem and answer options stay visible for context.
Question
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?
Options
- AThe materialized log should be dropped before the online table redefinition process.
- BTriggers with the PRECEDES clause should be disabled before the online table redefinition process.
- CReferential integrity constraints must be manually enabled after the online table redefinition process.
- DThe dependent materialized view should have a complete refresh performed after the online table
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.