nerdexam
Oracle

1Z0-083 · Question #180

1Z0-083 Question #180: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #180. The question stem and answer options stay visible for context.

Backup and Recovery

Question

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?

Options

  • AAll the triggers associated with the table are flashed back but are disabled.
  • BMaterialized views that use the CUSTOMERS table are flashed back.
  • CLOB segments associated with the CUSTOMERS table are flashed back.
  • DAll the constraints defined on the table, except the referential integrity constraints, are flashed
  • EOnly the primary key constraint created for the table is flashed back, whereas all other indexes

Unlock 1Z0-083 to see the answer

You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 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.

Topics

#FLASHBACK TABLE#Dependent Objects#LOB Segments#Constraints
Full 1Z0-083 Practice