um, I can see possible answers to this question being 2 teachers, 3 teachers
or 4 teachers.
however, since that isn't one of the multiple choice answers, then it has to
be "at least 4" since "only 2" is wrong
>From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: How do they get the answer?
>Date: Tue, 21 Aug 2001 09:27:46 -0800
>
>two subjects in the "in" clause, times at least two teachers per subject
>equals at least four records updated.
>
>sometimes it is easier to eliminate answers first.
>like, you can throw out d) syntax will occur. and b) all teachers will get
>an increase.
>you are then left with a) two teachers and c). at least four teachers.
>
>Since the "where" clause is looking at the 'subject_id' column, rather than
>the 'teacher_id' column, you can almost guess that it is c).
>
>hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Tuesday, August 21, 2001 12:26 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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: Mercadante, Thomas F
> 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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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).
