A.select INTERVAL '1' DAY +INTERVAL '1' MONTH FROM DUAL;

B.SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL;

C.SELECT SYSDATE "INTERRVAL '1' DAY FROM DUAL;

D.SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;

E.SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;

A.INDEX

B.REFERENCES

C.ALTER

D.INSERT

E.DELETE

F.UPDATE

G.SELECT

A.ROLLBACK to SAVEPOTNT undoes the transaction's changes made since the named savepoint and then ends the transaction.

B.ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.

C.ROLLBACK without the TO SAVEPOINT clause undoes alt the transaction's changes, releases its locks, and erases all its savepoints.

D.COMMIT ends the transaction and makes all its changes permanent.

E.COMMIT erases all the transaction's savepoints and releases its locks.

F.ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.

A.The number of columns in each select in the compound query can be different.

B.Column names in each select in the compound query can be different.

C.intersect returns rows common to both sides of the compound query.

D.Reversing the order of the intersected tables can sometimes affect the output.

E.intersect ignores nulls.

A.GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION:

B.GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;

C.GRANT CREATE TABLE, emp TO manager;

D.GRANT CREATE TABLE, SELECT ON hr. employees TO manager;

E.GRANT CREATE SEQUENCE TO manager, emp;