Which statement is true regarding Flashback Version Query?

Which statement is true regarding Flashback Version Query?

Which statement is true regarding Flashback Version Query?

A.
It returns versions of rows only within a transaction.

B.
It retrieves all versions including the deleted as well as subsequently reinserted versions
of the rows.

C.
It can be used in subqueries contained only in a SELECT statement.

D.
It will return an error if the undo retention time is less than the lower bound time or SCN
specified.



Leave a Reply 0

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