A. INSTR returns the numeric position of a named character.
B. NVL2 returns the first non-null expression in the expression list.
C. TRUNCATE rounds the column, expression, or value to n decimal places.
D. DECODE translates an expression after comparing it to each search value.
E. TRIM trims the heading of trailing characters (or both) from a character string.
F. NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.
G. NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.

A. CREATE VIEW emp_Vu AS   SELECT employee_id, emp_name,   department_id   FROM employees   WHERE mgr_id IN (102, 120);
B. CREATE VIEW emp_Vu AS   SELECT employee_id, emp_name, job_id   department_id   FROM employees   WHERE mgr_id IN (102, 120);
C. CREATE VIEW emp_Vu AS   SELECT department_id, SUM(sal) TOTALSAL   FROM employees   WHERE mgr_id IN (102, 120)   GROUP BY department_id;
D. CREATE VIEW emp_Vu AS   SELECT employee_id, emp_name, job_id,   DISTINCT department_id   FROM employees;