From ivo.libal@knapp-systems.com Wed, 22 Aug 2001 02:33:47 -0700
From: "Libal, Ivo" <ivo.libal@knapp-systems.com>
Date: Wed, 22 Aug 2001 02:33:47 -0700
Subject: RE: How do they get the answer?
Message-ID: <F001.00373921.20010822023134@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



I thing that the answer should 
be 
 
E) At 
least two teachers will receive a 10% salary 
increase.
<FONT 
face="MS Sans Serif" size=1><FONT face="MS Sans Serif" 
size=1> 
<FONT 
face="MS Sans Serif" size=1>Think if there are the same 2 teachers for class 
102,105....
<SPAN 
class=008533209-22082001> 
<FONT 
face="MS Sans Serif" size=1>Ivo
 From: Stephen 
Andert [mailto:StephenAndert@firsthealth.com]Sent: Tuesday, August 
21, 2001 06:57 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: How do they get the answer?

  Well, 
   
  to me it looks like 
      WHERE        subject_id 
  IN (102, 105);will select 2 classes. Since there are a minimum of 2 
  teachers per class, this will select at least 4 teachers.  
   
  Am I missing something?
   
  Stephen>>> kjanusz@att.net 08/21/01 09:25AM 
  >>>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?    
      TypeID        
          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 taughtby 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@att.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).