Datasheet

Review Questions 53
Review Questions
1. You issue the following query:
SELECT salary “Employee Salary”
FROM employees;
How will the column heading appear in the result?
A. EMPLOYEE SALARY
B. EMPLOYEE_SALARY
C. Employee Salary
D. employee_salary
2. The EMP table is defined as follows:
Column Datatype Length
EMPNO NUMBER 4
ENAME VARCHAR2 30
SALARY NUMBER 14,2
COMM NUMBER 10,2
DEPTNO NUMBER 2
You perform the following two queries:
1. SELECT empno enumber, ename
FROM emp ORDER BY 1;
2. SELECT empno, ename
FROM emp ORDER BY empno ASC;
Which of the following is true?
A. Statements 1 and 2 will produce the same result in data.
B. Statement 1 will execute; statement 2 will return an error.
C. Statement 2 will execute; statement 1 will return an error.
D. Statements 1 and 2 will execute but produce different results.
95127c01.indd 53 2/18/09 6:37:11 AM