RE: How do they get the answer?

[eric harrington]

I agree with Joe, the correct answer is two. It doesn't state that a teacher can only teach one subject so the same two teachers can teach both subjects. I also agree with everyone that mentioned that this is a crappy question. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTA Sent: Tuesday, August 21, 2001 2:52 PM To: Multiple recipients of list ORACLE-L Subject: Re: How do they get the answer? i still stand by(reading into the question) that it could be only 2 teachers get a raise, if the same 2 teachers teach both of those courses.  would they get twice as much of a raise? :)   joe >>> [EMAIL PROTECTED] 08/21/01 12:52PM >>> in the where clause, the IN says "any teachers that are in any of these subjects. Since there are two subjects in the IN set and at least 2 teachers have to teach each subject, 2*2=4. Basic mathematics: at least 4 teachers will get a raise. Jon Walthour > > From: [EMAIL PROTECTED] > Date: 2001/08/21 Tue PM 12:25:54 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: How do they get the answer? > > 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: Jon Walthour   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).