多项选择题
Which two are true about aggregate functions? （）
A.You can use aggregate functions in any clause of a SELECT statement.
B.You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
C.You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
D.You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
E.You can use aggregate functions on a table, only by grouping the whole table as one single group.
F.You cannot group the rows of a table by more than one column while using aggregate functions.
相关考题
-
单项选择题
Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）
A. 17000.00
B. 17000*****
C. ****170.00
D. **17000.00
E.an error statement -
单项选择题
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain SA_ in the JOB_ID column. Which SQL statement do you use?（）
A.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE '\';
B.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\";
D.SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_'; -
单项选择题
Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMPLOYEES e, DEPARTMENTS d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）
A.selection, projection, join
B.difference, projection, join
C.selection, intersection, join
D.intersection, projection, join
E.difference, projection, product
