1Z0-067 · Question #85
Examine the command and its output: SQL> DROP TABLE EMPLOYEE; SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE…
The correct answer is A. It flashes back the employee table and all the constraints associated with the table. C. It automatically flashes back any triggers defined on the table. A table and all of its dependent objects (indexes, LOB segments, nested tables, triggers, constraints and so on) go into the recycle bin together, when you drop the table. Likewise, when you perform Flashback Drop, the objects are generally all retrieved together. Trigger…
Question
Examine the command and its output:
SQL> DROP TABLE EMPLOYEE; SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE ----------------------------------------------------------------------- binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP; Which two statements are true?
Options
- AIt flashes back the employee table and all the constraints associated with the table.
- BIt automatically flashes back all the indexes on the employes table.
- CIt automatically flashes back any triggers defined on the table.
- DIt flashes back only the structure of the table and not the data.
- EIt flashes back the data from the recycle bin and the existing data in the original table is
How the community answered
(51 responses)- A76% (39)
- B4% (2)
- D14% (7)
- E6% (3)
Explanation
A table and all of its dependent objects (indexes, LOB segments, nested tables, triggers, constraints and so on) go into the recycle bin together, when you drop the table. Likewise, when you perform Flashback Drop, the objects are generally all retrieved together. Trigger automatically flashbacked.
Topics
Community Discussion
No community discussion yet for this question.