READ Free Dumps For Oracle- 1z0-047
| Question ID 6435 | Which two statements are true regarding operators used with subqueries? (Choose two.) |
| Option A | The NOT IN operator is equivalent to IS NULL. |
| Option B | The |
| Option C | . =ANY and =ALL operators have the same functionality. |
| Option D | The IN operator cannot be used in single-row subqueries. |
| Option E | The NOT operator can be used with IN, ANY and ALL operators. |
| Correct Answer | BE |
| Question ID 6436 | Given below are the SQL statements executed in a user session: CREATE TABLE product (pcode NUMBER(2), pname VARCHAR2(10)); INSERT INTO product VALUES(1, 'pen'); INSERT INTO product VALUES (2,'pencil'); SAVEPOINT a; UPDATE product SET pcode = 10 WHERE pcode = 1; SAVEPOINT b; DELETE FROM product WHERE pcode = 2; COMMIT; DELETE FROM product WHERE pcode=10; ROLLBACK TO SAVEPOINT a; Which statement describes the consequences? |
| Option A | No SQL statement would be rolled back. |
| Option B | Both the DELETE statements would be rolled back |
| Option C | Only the second DELETE statement would be rolled back |
| Option D | Both the DELETE statements and the UPDATE statement would be rolled back. |
| Correct Answer | A |