Which three are true about requirements for various FLASHBACK operations? (Choose three.)

The correct answer is A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON. F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between. https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm#ADMIN01511 When you drop a table, the database does not immediately remove the space associated with the table. The database renames the table and places it and any associated objects in a recycle bin, where…

Configure for Recoverability

Question

Options

AFLASHBACK transaction query requires undo to retrieve all versions of a row that existed
BFLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
CFLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
DFLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being
EFLASHBACK drop requires undo to retrieve all versions of a row that existed between two points
FFLASHBACK version query requires undo to retrieve all versions of a row that existed between

How the community answered

(21 responses)

A
76% (16)
C
5% (1)
D
5% (1)
E
14% (3)

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm#ADMIN01511 When you drop a table, the database does not immediately remove the space associated with the table. The database renames the table and places it and any associated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time. This feature is called Flashback Drop, and the FLASHBACK TABLE statement is used to restore the table.

Topics

#FLASHBACK operations#undo retention#RECYCLEBIN parameter#FLASHBACK version query

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice