Re: more ocp exam question

From: <jlong53_at_my-deja.com>
Date: 2000/03/29
Message-ID: <8btv86$u4o$1@nnrp1.deja.com>#1/1

This is really a smart answer.

Take a look of this question:

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 <954312285.15113.0.nnrp-10.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> If the question has been quoted correctly, then
> the correct answer has not been supplied as an
> option -
>
> The command to open a 'cursor for loop' is FOR ;)
>
> If the question read:
> What is the command used to open the
> cursor used in a 'cursor for loop' the answer
> the answer would be D.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Sybrand Bakker wrote in message
> <954306846.12155.0.pluto.d4ee154e_at_news.demon.nl>...
> >The correct answer is D
> >the full syntax is
> >for record_var in cursorvar loop
> > end loop;
> >The open is handled implicitly.
> >
> >Regards,
> >
> >Sybrand Bakker, Oracle DBA
> >
> ><jlong53_at_my-deja.com> wrote in message
news:8brcka$1gk$1_at_nnrp1.deja.com...
> >> I wonder how many people do the self-test for preparing oracle dba
> >> exam. For some examples, it is more confusing than the real test:
> >>
> >> ============================================
> >>
> >> You are developing PL/SQL process flow into your program. The
command
> >> used to open a cursor for loop is which of the following keywords?
> >>
> >>
> >>
> >> A. open
> >>
> >> B. fetch
> >>
> >> C. parse
> >>
> >> D. None, cursor for loops handle cursor opening implicitly.
> >>
> >> Answer : D
>
>

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