Yes, if 102 and 105 are valid subject_id codes. The correct answer is "Not
enough data has been supplied to properly evaluate the results."
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Deshpande, Kirti"
<kirti.deshpande@ve To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
rizon.com> cc:
Sent by: Subject: RE: How do they get the
answer?
[EMAIL PROTECTED]
08/21/2001 12:03 PM
Please respond to
ORACLE-L
>> Each subject is taught by at least 2 teachers.
So, if 102 and 105 are the 2 subject-ids, then a total of at least 4
teachers will get selected for salary update.
Correct ?
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 11:26 AM
> To: Multiple recipients of list ORACLE-L
> 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: Deshpande, Kirti
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:
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).