You issued this command: Which three statements are true? (Choose three.)

The correct answer is A. Views referencing HR.EMPLOYEES are dropped. B. All constraints defined on HR.EMPLOYEES are dropped. E. All indexes defined on HR.EMPLOYEES are dropped. https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables010.htm#ADMIN01505

Using DDL Statements to Create and Manage Tables

Question

You issued this command:

Which three statements are true? (Choose three.)

Options

AViews referencing HR.EMPLOYEES are dropped.
BAll constraints defined on HR.EMPLOYEES are dropped.
CSequences used to populate columns in the HR.EMPLOYEES table are dropped.
DThe HR.EMPLOYEES table may be moved to the recycle bin.
EAll indexes defined on HR.EMPLOYEES are dropped.
FSynonyms for HR.EMPLOYEES are dropped.

How the community answered

(25 responses)

A
84% (21)
C
4% (1)
D
8% (2)
F
4% (1)

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables010.htm#ADMIN01505

Topics

#DROP TABLE#recycle bin#cascade effects#DDL

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice