Which of the following statements is true regarding the VERSIONS BETWEEN clause?

Which of the following statements is true regarding the VERSIONS BETWEEN clause?

Which of the following statements is true regarding the VERSIONS BETWEEN clause?

A.
The VERSIONS BETWEEN clause may be used in DML statements.

B.
The VERSIONS BETWEEN clause may be used in DDL statements.

C.
The VERSIONS BETWEEN clause may not be used to query past DDL changes to
tables.

D.
The VERSIONS BETWEEN clause may not be used to query past DML statements to
tables.

Show Hint

Leave a Reply 1

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

Eamon

Eamon

I found this question in my notes, here is the answer supplied. (I cannot supply the source of this, also note that the answer supplied here is not my opinion)
Here is the answer supplied …

C. The VERSIONS BETWEEN clause of the Flashback Versions Query cannot query past table modifications or DDL changes to a table.

Reply