| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How do they get the answer?
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" <NDATFM_at_labor.state.ny.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: kjanusz_at_att.net
>
>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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us
>
>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: ListGuru_at_fatcity.com (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: Rachel Carmichael INET: carmichr_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Tue Aug 21 2001 - 13:31:50 CDT
 |
 |