Which three statements about the HR.EMPLOYEES table are true?

Exhibit:
View the Exhibit that displays a part of the Perform Recovery: Review page. Which three statements about the HR.EMPLOYEES table are true? (Choose three.)

View the Exhibit that displays a part of the Perform Recovery: Review page.

Which three statements about the HR.EMPLOYEES table are true? (Choose three.)

A.
The HR.EMPLOYEES table would be recovered from the Recycle Bin.

B.
The HR.EMPLOYEES table can be flashed back only by its owner.

C.
The HR.EMPLOYEES table can be flashed back after it is deleted or purged.

D.
The dependent objects of the HR.EMPLOYEES table can be optionally flashed back.

E.
The dependent objects of the HR.EMPLOYEES table are automatically flashed back.

F.
The HR.EMPLOYEES table can be flashed back only if it resides in a locally managed tablespace.

G.
The HR.EMPLOYEES table can be flashed back only if it resides in a dictionary-managed tablespace.

Explanation:

http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
E :Note: When you flashback a table, Oracle will recover the dependent objects (except bitmap indexes) as well, but they will continue to have their cryptic …



Leave a Reply 0

Your email address will not be published. Required fields are marked *