Oracle Exam 1Z0-063 Topic 2 Question 29 Discussion

Actual exam question for Oracle's 1Z0-063 exam

Question #: 29
Topic #: 2

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? (Choose two.)

AOnly the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

BAll the constraints defined on the table, except the referential integrity constraints, are flashed back.

CAll the triggers associated with the table are flashed back but are disabled.

DMaterialized views that use the CUSTOMERS table are flashed back.

ELOB segments associated with the CUSTOMERS table are flashed back.

Show Suggested Answer

Suggested Answer: B, E

B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that reference other tables.

by Renea at May 08, 2022, 11:40 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!