READ Free Dumps For Oracle- 1z0-047
| Question ID 6429 | Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true regarding the above FLASHBACK operation? |
| Option A | It recovers only the first DEPT table. |
| Option B | It recovers only the second DEPT table |
| Option C | It does not recover any of the tables because FLASHBACK is not possible in this case |
| Option D | It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN. |
| Correct Answer | B |
| Question ID 6430 | 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 http://www.gratisexam.com/ VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE; What would be the outcome of the above query? |
| Option A | It would not display any values |
| Option B | It would display the value TWO once. |
| Option C | It would display the value TWO twice |
| Option D | . It would display the values ONE, TWO, and TWO. |
| Correct Answer | C |