Oracle
1Z0-052 · Question #20
1Z0-052 Question #20: Real Exam Question with Answer & Explanation
The correct answer is A: No flashback is possible to bring back the ITEM table.. See the full explanation below for the reasoning.
Question
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about the effect of the command? (Choose two.)
Options
- ANo flashback is possible to bring back the ITEM table.
- BThe ORDERS table is dropped along with the ITEM table.
- CThe dependent referential integrity constraints in the ORDERS table are disabled.
- DThe dependent referential integrity constraints in the ORDERS table are removed.
- EThe table definition of the ITEM table and associated indexes are placed in the recycle bin.
Community Discussion
No community discussion yet for this question.