Which two statements are correct in this scenario?

View the Exhibit.
A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery, you choose 2004343 as the Flashback SCN.
Which two statements are correct in this scenario? (Choose two.)
Exhibit:

View the Exhibit.

A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery, you choose 2004343 as the Flashback SCN.

Which two statements are correct in this scenario? (Choose two.)

A.
Only the row with DEPARTMENT_ID 290 would be flashed back.

B.
The rows with DEPARTMENT_ID 290 and 300 would be flashed back.

C.
The rows with DEPARTMENT_ID 290 and 280 would be flashed back.

D.
You would have taken the USERS tablespace offline before starting the Flashback Table operation.

E.
You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.



Leave a Reply 2

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


spudman

spudman

you left off the exhibit.

admin

admin

The exhibit was supplied.