You want to change your database by adding some new columns to a particular tale.These new columns represent new data th
Posted: Sun Jun 11, 2023 4:00 pm
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.
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.