ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-061 All Questions

View all questions & answers for the 1z0-061 exam
Go to Exam

Exam 1z0-061 topic 4 question 95 discussion

Actual exam question from Oracle's 1z0-061
Question #: 95
Topic #: 4
[All 1z0-061 Questions]

Examine the structure of the DEPARTMENTS table:

You execute the following command:

SQL> ALTER TABLE departments -
SET UNUSED (country);
Which two statements are true? (Choose two.)

  • A. Synonyms existing om the DEPARTMENTS table would have to be re-created.
  • B. Unique key constraints defined on the COUNTRY column are removed.
  • C. Views created on the DEPARTMENTS table that include the COUNTRY column are automatically modified and remain valid.
  • D. Indexes created on the COUNTRY column exist until the DROP UNUSED COLUMNS command is executed.
  • E. A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
by Iyavap at Feb. 24, 2020, 10:21 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
winston
1 year, 5 months ago
Why is D wrong?
upvoted 1 times
...
Iyavap
4 years, 11 months ago
Right Answer: B,E
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago