RE: How do they get the answer?

From: eric harrington <eharrington_at_ecora.com>
Date: Tue, 21 Aug 2001 12:21:37 -0700
Message-ID: <F001.0037306E.20010821121346@fatcity.com>

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.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_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_at_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_at_att.net>   Date: 2001/08/21 Tue PM 12:25:54 EDT> To: Multiple recipients of list   ORACLE-L <ORACLE-L_at_fatcity.com>> 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: <A
  href="http://www.orafaq.com">http://www.orafaq.com> -- >   Author: >   INET: kjanusz_at_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_at_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: <A href="http://www.orafaq.com">http://www.orafaq.com-- Author: Jon Walthour  INET: jonw_at_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_at_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).

Received on Tue Aug 21 2001 - 14:21:37 CDT