Oracle
1Z0-514 · Question #17
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…
The correct answer is B. Add the columns to the table, since dependent objects will not be affected. See the full explanation below for the reasoning.
Question
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?
Options
- AUse edition-based redefinition to create a new version of the table.
- BAdd the columns to the table, since dependent objects will not be affected.
- CEncompass all access to these columns in separate PL/SQL procedures to avoid dependency issues.
- DAdd the columns to a different table and create a view to access the joined result.
How the community answered
(25 responses)- A8% (2)
- B80% (20)
- C4% (1)
- D8% (2)
Community Discussion
No community discussion yet for this question.