Oracle
1Z0-497 · Question #75
The RECYCLEBIN parameter is set to onfor your database. You drop a table, PRODUCTS, from the SCOTTschema. Which two statements are true regarding the outcome of this action? (Choose two.)
The correct answer is C. Only the related indexes are dropped whereas views are invalidated. D. TheFlashback Drop feature can recover both the table structure and its data. See the full explanation below for the reasoning.
Question
The RECYCLEBIN parameter is set to onfor your database. You drop a table, PRODUCTS, from the SCOTTschema. Which two statements are true regarding the outcome of this action? (Choose two.)
Options
- AAll the related indexes and views are automatically dropped.
- BThe Flashback Drop feature can recover only the table structure.
- COnly the related indexes are dropped whereas views are invalidated.
- DTheFlashback Drop feature can recover both the table structure and its data
How the community answered
(48 responses)- A8% (4)
- B17% (8)
- C75% (36)
Community Discussion
No community discussion yet for this question.