Oracle Database 12c: Multitenancy Essentials — Question 14

You have altered an index supporting a constraint to be invisible on a large data warehouse table in an X5 Database Machine.
Which two statements are true?

Answer options

• A. You might retain the index, and leave it as invisible, and the constraint will still be recognized and enforced.
• B. You must retain the index and make it visible again for the constraint to be recognized and enforced.
• C. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY for the constraint to be recognized.
• D. You might drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags for the constraint to be recognized.
• E. You might drop the index and make the constraint invisible, for the constraint to be recognized and enforced.

Correct answer: B, C

Explanation

Option B is correct because the index must be visible for the constraint to be enforced. Option C is also correct as it allows the constraint to be recognized even if the index remains invisible, but it requires the specific setting. The other options are incorrect because they suggest dropping the index or altering the constraint in ways that do not guarantee the enforcement of the constraint.