📝 Question
#1682
Evaluate the following statements: CREATE TABLE digits (id NUMBER(2), description VARCHAR2(15)); INSERT INTO digits VALUES (1,'ONE); UPDATE digits SET description ='TWO'WHERE id=1; INSERT INTO digits VALUES (2 ,'TWO'); COMMIT; DELETE FROM digits; SELECT description FROM digits VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE;
✓
Correct Answer
A. It would not display any values
💡
Explanation
The VERSIONS BETWEEN clause of the SELECT statement is used to create a Flashback Version Query.
⌨️ Press
A
B
C
D
to select