A.SELECT first_ name, DISTINCT last_ name FROM employees WHERE first_ name < > NULL;

B.SELECT first_ name, DISTNCT last_ name FROM employees WHERE first_ name IS NOT NULL;

C.SELECT DISTINCT * FROM employees WHERE first_ name IS NOT NULL;

D.SELECT Distinct * FROM employees WHERE first_ name < > NULL;

A.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsal FROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary);

B.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsal FROM employeesWHERE hire_date < SYSDATE-365)GROUP BY maxsal, minsal;

C.SELECT MIN(Salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary);

D.SELECT MIN(Salary), MAX(salary)FROM (SELECT salary FROM employeesWHERE hire_date < SYSDATE-365);

A.when a PL/SQL anonymous block is executed

B.when a DELETE statement is executed

C.when a ROLLBACK command is executed

D.when a data definition language (DDL) statement is executed

E.when a TRUNCATE statement is executed after the pending transaction

A.All data along with the table structure is deleted.

B.A pending transaction in the session is committed.

C.All indexes on the table remain but they are invalidated.

D.All views and synonyms on the table remain but they are invalidated.

E.All data in the table is deleted but the table structure remains.

A.WHERE TO_CHAR(order_date,'MON DD YYYY') = 'JAN 20 2003'

B.2003','MON DD YYYY') )
WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE,6),'MON DD YYYY')

C.WHERE order_date > TO_DATE('JUL 10 2006','MON DD YYYY')

D.Which two WHERE clause conditions demonstrate the correct usage of conversion functions? (Choose two.) WHERE order_date_IN ( TO_DATE('OCT 21 2003','MON DD YYYY'), TO_CHAR('NOV 21