I want to thank everyone who gave me input on this
question. It was most helpful.
Ken Janusz, CPIM
> um, I can see possible answers to this question being 2 teachers, 3 teachers
> or 4 teachers.
>
> however, since that isn't one of the multiple choice answers, then it has to
> be "at least 4" since "only 2" is wrong
>
>
> >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: How do they get the answer?
> >Date: Tue, 21 Aug 2001 09:27:46 -0800
> >
> >two subjects in the "in" clause, times at least two teachers per subject
> >equals at least four records updated.
> >
> >sometimes it is easier to eliminate answers first.
> >like, you can throw out d) syntax will occur. and b) all teachers will get
> >an increase.
> >you are then left with a) two teachers and c). at least four teachers.
> >
> >Since the "where" clause is looking at the 'subject_id' column, rather than
> >the 'teacher_id' column, you can almost guess that it is c).
> >
> >hope this helps.
> >
> >Tom Mercadante
> >Oracle Certified Professional
> >
> >
> >-----Original Message-----
> >Sent: Tuesday, August 21, 2001 12:26 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >I am taking the Self-Test software test for the SQL exam
> >and don't see how they get the answer to this problem.
> >They don't explain how it is arrived at.
> >
> >Any help you can give me will be appreciated.
> >
> >Thanks,
> >Ken Janusz, CPIM
> >
> >----------------------------------
> >
> >Examine the structure of the TEACHER table:
> >
> >Name Null? Type
> >ID NOT NULL NUMBER(9)
> >SALARY NUMBER
> >(7,2)
> >SUBJECT_ID NOT NULL NUMBER(3)
> >SUBJECT_DESCRIPTION VARCHAR2(2)
> >
> >There are 200 teachers and 15 subjects. Each subject is
> >taught
> >by at least 2 teachers.
> >
> >Evaluate this PL/SQL block:
> >
> >DECLARE
> > v_pct_raise number := 1.10;
> >BEGIN
> > UPDATE teacher
> > SET salary = salary * 1.10
> > WHERE subject_id IN (102, 105);
> > COMMIT;
> >END;
> >
> >Which result will the PL/SQL block provide?
> >
> >(A) Only two teachers will receive a 10% salary increase.
> >(B) All of the teachers will receive a 10% salary
> >increase.
> >(C) At least four teachers will receive a 10% salary
> >increase.
> >(D) A syntax error will occur.
> >
> >Answer:
> >(C)
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> > INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Mercadante, Thomas F
> > INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).