Oracle Database: Program with PL/SQL — Question 16

Which two statements are true regarding edition-based redefinition (EBR)?

Answer options

• A. There is no default edition defined in the database.
• B. EBR does not let you upgrade the database components of an application while in use.
• C. You never use EBR to copy the database objects and redefine the copied objects in isolation.
• D. Editions are non-schema objects.
• E. When you change an editioned object, all of its dependents remain valid.
• F. Tables are not editionable objects.

Correct answer: E, F

Explanation

Option E is correct because editioned objects can be modified while their dependents maintain validity. Option F is correct as tables are not classified as editionable objects in EBR. The other options contain inaccuracies regarding the nature and functioning of EBR.