Oracle
1Z0-043 · Question #10
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…
The correct answer is 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. See the full explanation below for the reasoning.
Question
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.)
Options
- AIt cannot be used in RECOVER DATABASE operations.
- BIt can work only if logging for Flashback Database is enabled.
- CIt creates logs in the flash recovery area that would not be deleted even if there is space pressure.
- DIt can be used to reverse the effects of NOLOGGING operations like in the case of direct load inserts.
How the community answered
(66 responses)- A15% (10)
- B8% (5)
- C77% (51)
Community Discussion
No community discussion yet for this question.