From eharrington@ecora.com Tue, 21 Aug 2001 12:21:37 -0700 From: "eric harrington" Date: Tue, 21 Aug 2001 12:21:37 -0700 Subject: RE: How do they get the answer? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of JOE TESTASent: Tuesday, August 21, 2001 2:52 PMTo: Multiple recipients of list ORACLE-LSubject: 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 >>> jonw@fuse.net 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: kjanusz@att.net> Date: 2001/08/21 Tue PM 12:25:54 EDT> To: Multiple recipients of list ORACLE-L > 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: kjanusz@att.net> > 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: ListGuru@fatcity.com (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: jonw@fuse.netFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).