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_at_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_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 - 12:36:18 CDT
