Re: How do they get the answer?

From: Regina Harter <rharter_at_emc-inc.com>
Date: Tue, 21 Aug 2001 12:34:40 -0700
Message-ID: <F001.00373107.20010821122725@fatcity.com>

The structure of the table indicates to me that they began with the assumption that each teacher would only be teaching one subject.

At 10:52 AM 8/21/01 -0800, you wrote:
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:

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:
http://www.orafaq.com
-- 
Author: Jon Walthour
  INET: jonw_at_fuse.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).

Received on Tue Aug 21 2001 - 14:34:40 CDT