an assumption is made that the same 2 teachers are not teaching subject 102
and 105 for if they were then, only 2 teachers would be getting raises.
but if you go with 4 different teachers are teaching that class(2 groups of
2) then answer c would be correct.
I think C SHOULD say at least 2 teachers will be getting a raise.
but thats just my opinion. :)
joe
>>> kjanusz_at_att.net 08/21/01 12:25PM >>>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_at_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_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 - 10:34:18 CDT
