多项选择题
Which four statements correctly describe functions that are available in SQL? （）
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 or trailing characters (or both) from a character string.
F.NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.
G.NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
相关考题
-
单项选择题
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_ NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?（）
A.SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;
B.SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
C.SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
D.SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
E.SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) < 5000 AND MAX(salary) > 15000; -
多项选择题
Which are DML statements? （）
A.COMMIT
B.MERGE
C.UPDATE
D.DELETE
E.CREATE
F.DROP... -
单项选择题
In which case would you use a FULL OUTER JOIN?（）
A.Both tables have NULL values.
B.You want all unmatched data from one table.
C.You want all matched data from both tables.
D.You want all unmatched data from both tables.
E.One of the tables has more data than the other.
F.You want all matched and unmatched data from only one table.
