Datasheet

58 Chapter 1

Introducing SQL
What will be the value in the first row of the result set when the following query is executed?
SELECT hire_date FROM employee
ORDER BY salary, emp_name;
A. 02-APR-91
B. 17-DEC-90
C. 28-SEP-91
D. The query is invalid, because you cannot have a column in the ORDER BY clause that is
not part of the SELECT clause.
18. Which SQL statement will query the EMPLOYEES table for FIRST_NAME, LAST_NAME, and
SALARY of all employees in DEPARTMENT_ID 40 in the alphabetical order of last name?
A. SELECT first_name last_name salary
FROM employees
ORDER BY last_name
WHERE department_id = 40;
B. SELECT first_name, last_name, salary
FROM employees
ORDER BY last_name ASC
WHERE department_id = 40;
C. SELECT first_name last_name salary
FROM employees
WHERE department_id = 40
ORDER BY last_name ASC;
D. SELECT first_name, last_name, salary
FROM employees
WHERE department_id = 40
ORDER BY last_name;
E. SELECT first_name, last_name, salary
FROM TABLE employees
WHERE department_id IS 40
ORDER BY last_name ASC;
19. When doing pattern matching using the LIKE operator, which character is used as the
default escape character by Oracle?
A. |
B. /
C. \
D. There is no default escape character in Oracle.
95127c01.indd 58 2/18/09 6:37:12 AM