Oracle
1Z0-071 · Question #254
Examine the structure of the DEPARTMENTS table. You execute the following command: Which two statements are true? (Choose two.)
The correct answer is B. Unique key constraints defined on the COUNTRY column are removed. E. A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the. See the full explanation below for the reasoning.
Question
Examine the structure of the DEPARTMENTS table. You execute the following command:
Which two statements are true? (Choose two.)
Exhibit
Options
- ASynonyms existing of the DEPARTMENTS table would have to be re-created.
- BUnique key constraints defined on the COUNTRY column are removed.
- CViews created in the DEPARTMENTS table that include the COUNTRY column are automatically
- DIndexes created on the COUNTRY column exist until the DROP UNUSED COLUMNS command
- EA new column, COUNTRY, can be added to the DEPARTMENTS table after executing the
How the community answered
(25 responses)- A4% (1)
- B76% (19)
- C12% (3)
- D8% (2)
Community Discussion
No community discussion yet for this question.
