Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 26 of 50

Marks: +1, -0

Examine the structure of the DEPARTMENTS table.

Which two statements are true? (Choose two.)

Synonyms existing of the DEPARTMENTS table would have to be re-created.
Unique key constraints defined on the COUNTRY column are removed.
Views created in the DEPARTMENTS table that include the COUNTRY column are automatically modified and remain valid.
Indexes created on the COUNTRY column exist until the DROP UNUSED COLUMNS command is executed.
A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command.

Go to Question:

Prev Question

Next Question