Re: More OCP Sample Test Questions

But, it would seem that the answer would still be "C".....the query doesn't solve the stated problem, but all three criteria would have to be met to be selected? It might not return anyone because nobody met all three criteria

john

www_dba_at_my-deja.com wrote:

> 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