1. The following statement represents a multi-row function. True or False?
SELECT MAX(salary)
FROM employees
True (*)
False
2. The conversion function TO_CHAR is a single row function. True or False?
True (*)
False
3. Will the following statement return one row?
SELECT MAX(salary), MIN(Salary), AVG(SALARY)
FROM employees;
No, it is illegal. You cannot use more than one multi-row function in a SELECT statement
Yes, it will return the highest salary, the lowest salary and the average salary from all employees (*)
Yes, it will return the highest salary from each employee
Yes, it will return the average salary from the employees table.
4. The following statement represents a multi-row function. True or False?
SELECT UPPER(last_name)
FROM employees;
True
False (*)
5. The function COUNT is a single row function. True or False?
True
False (*)
