More OCP Sample Test Questions

From: <jlong53_at_my-deja.com>
Date: 2000/03/27
Message-ID: <8bopnu$4h5$1@nnrp1.deja.com>#1/1

I download the self-test program for oracle dba exam test 1 and run into this question.

---

The EMPLOYEE table contains these columns:

FIRST_NAME	VARCHAR2(25)
LAST_NAME	VARCHAR2(25)

JOB VARCHAR2(25)
SALARY NUMBER(7,2)
DEPT_ID NUMBER(3)
You need to display the first name and last name for employees whose:

1. Last Name is Brown, Chan, or Lindsey.
2. Job is Manager, Technician, or Clerk.
3. Salary is greater than 30000.
You issue this SQL statement:
SELECT	first_name, last_name
FROM	employee
WHERE	UPPER(last_name) IN ('BROWN', 'CHAN', 'LINDSEY')
AND	UPPER(job) IN ('MANAGER', 'TECHNICIAN', 'CLERK')
AND	salary <= 30000;

Which employees are displayed?

A. Those who meet only one requirement
B. Those who meet only two requirements
C. Those who meet all three requirements
D. Those who meet none of the requirements

Answer is C.

---

This is too strange. I feel it is an error. It should be C. Any idea?
Thax,
J

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 27 2000 - 00:00:00 CST