Oracle
1Z0-067 · Question #85
1Z0-067 Question #85: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #85. The question stem and answer options stay visible for context.
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
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.