1Z0-043 practice - PrepKeys

Q4 Multiple choice

You issue the following command in your database:

CREATE RESTORE POINT rec_load
GUARANTEE FLASHBACK DATABASE;

Which two statements are true regarding the REC_LOAD guaranteed restore point? (Choose two.)

Select all that apply.

A
It cannot be used in RECOVER DATABASE operations.
B
It can work only if logging for Flashback Database is enabled.
C
It creates logs in the flash recovery area that would not be deleted even if there is space pressure.
D
It can be used to reverse the effects of NOLOGGING operations like in the case of direct load inserts.