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

Exam 1z0-071 All Questions

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

Exam 1z0-071 topic 1 question 92 discussion

Actual exam question from Oracle's 1z0-071
Question #: 92
Topic #: 1
[All 1z0-071 Questions]

You issued this command:

DROP TABLE hr.employees;

Which three statements are true? (Choose three.)

  • A. Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
  • B. Synonyms for HR.EMPLOYEES are dropped.
  • C. Views referencing HR.EMPLOYEES are dropped.
  • D. All constraints defined on HR.EMPLOYEES are dropped.
  • E. The HR.EMPLOYEES table may be moved to the recycle bin.
  • F. All indexes defined on HR.EMPLOYEES are dropped
Show Suggested Answer Hide Answer
Suggested Answer: DEF 🗳️
by Sushmasri at July 31, 2023, 2:38 p.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
2339ac0
2 months, 1 week ago
Selected Answer: DEF
DEF is the right answer.
upvoted 1 times
...
826cb95
2 months, 2 weeks ago
Selected Answer: BDF
Synonyms for HR.EMPLOYEES are dropped. When you drop a table, any synonyms that point to that table are automatically dropped because the underlying object no longer exists.
upvoted 1 times
...
yaya32
12 months ago
Selected Answer: DEF
DEF for me
upvoted 3 times
...
Mcromeo
1 year, 1 month ago
Selected Answer: DEF
DEF is correct
upvoted 1 times
...
zangado
1 year, 1 month ago
Selected Answer: DEF
I think the same as lucemqy and jm9999
upvoted 1 times
...
lucemqy
1 year, 2 months ago
Selected Answer: DEF
Views and synonyms are not dropped but invalid
upvoted 1 times
...
jm9999
1 year, 3 months ago
Selected Answer: EF
For me, only EF proved to be true. The constraint was still listed in user_constraints after issuing the drop. I think ABC are definitely false and you have to pick 3 so ....
upvoted 1 times
...
captainkul
1 year, 4 months ago
D,E,F are correct
upvoted 1 times
...
jm9999
1 year, 4 months ago
DEF, I think synonyms and views are invalidated but not dropped
upvoted 2 times
...
Sushmasri
1 year, 5 months ago
Selected Answer: BCD
B,C,D are correct
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