You execute this command: Which two are true? (Choose two.)

The correct answer is D. It retains the integrity constraints defined on the table. E. It retains the indexes defined on the table. https://docs.oracle.com/html/E25494_01/general003.htm

Manipulating Data

Question

You execute this command:

Which two are true? (Choose two.)

Options

AIt drops any triggers defined on the table.
BIt always retains the space used by the removed rows.
CA ROLLBACK statement can be used to retrieve the deleted data.
DIt retains the integrity constraints defined on the table.
EIt retains the indexes defined on the table.
FA FLASHBACK TABLE statement can be used to retrieve the deleted data.

How the community answered

(18 responses)

A
6% (1)
C
6% (1)
D
78% (14)
F
11% (2)

Explanation

https://docs.oracle.com/html/E25494_01/general003.htm

Topics

#TRUNCATE#DDL#integrity constraints#indexes

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice