| 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?
Multiple choice exams are lousy at testing creative, imaginative people, because the answer ends up being "it depends" almost every time!
Hmmm, I wonder why they use them in universities...
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
-----Original Message-----
From: JOE TESTA [SMTP:JTESTA_at_longaberger.com]
Sent: Tuesday, August 21, 2001 3:52 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: How do they get the answer?
i still stand by(reading into the question) that it could be only 2
teachers get a raise, if the same 2 teachers teach both of those courses.
would they get twice as much of a raise? :)
joe
>>> jonw_at_fuse.net 08/21/01 12:52PM >>>
in the where clause, the IN says "any teachers that are in any of
these subjects. Since there are two subjects in the IN set and at least 2
teachers have to teach each subject, 2*2=4. Basic mathematics: at least 4
teachers will get a raise.
Jon Walthour
>
> From: kjanusz_at_att.net
> Date: 2001/08/21 Tue PM 12:25:54 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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
<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
<http://www.orafaq.com>
--
Author: Jon Walthour
INET: jonw_at_fuse.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: Boivin, Patrice J INET: BoivinP_at_mar.dfo-mpo.gc.ca 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:50:18 CDT
 |
 |