I'm heading back to the espresso machine now...
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).