Re: More OCP Sample Test Questions

If I am right,
it is <= not >.

In article <8bopnu$4h5$1_at_nnrp1.deja.com>, jlong53_at_my-deja.com wrote:
> 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.
>

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