Re: More OCP Sample Test Questions

From: <jlong53_at_my-deja.com>
Date: 2000/03/28
Message-ID: <8br9kh$tqi$1@nnrp1.deja.com>#1/1

I wonder if this is an English test more than a DBA test:

Check out this question:

No search criteria for the EMP table are known. Which of the following options is appropriate for use when search criteria is unknown for comparison operations in a select statement? (Choose two)

select * from emp where empid = &empid;
select * from emp where empid = 69494;
select * from emp where empid =(select empid from invoice where invoice_no = 4399485);
select * from emp;

Answer is A and C.

Boy, I think c is definitely wrong since we don't know if the subguery will return more than a row.

This is pretty frustrating.
Thanx,
J

In article <38E111C7.492A2FEC_at_napanet.net>, John Wilson <jwilson_at_napanet.net> wrote:
> 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.
>
>

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