You want to change your database by adding some new columns to a particular tale. These new
columns represent new data that is not accessed by the current application.
Which approach would be the simplest in making these changes?
A.
Use edition-based redefinition to create a new version of the table.
B.
Add the columns to the table, since dependent objects will not be affected.
C.
Encompass all access to these columns in separate PL/SQL procedures to avoid dependency
issues.
D.
Add the columns to a different table and create a view to access the joined result.
Explanation:
Are you sure about this? I think that answer is A
Question asks “Which approach would be simplest”
It does not ask which approach is best.
Answer B looks correct to me.