RE: How do they get the answer?
I thing that the answer should be E) At leasttwo teachers will receive a 10% salary increase. Think if there are the same 2 teachers for class 102,105 Ivo From: Stephen Andert [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 06:57 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How do they get the answer? 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 [EMAIL PROTECTED] 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: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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).
RE: How do they get the answer?
I want to thank everyone who gave me input on this question. It was most helpful. Ken Janusz, CPIM 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 NULLNUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULLNUMBER(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). -- 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
Re: How do they get the answer?
an assumption is made that the same 2 teachers are not teaching subject 102 and 105 for if they were then, only 2 teachers would be getting raises. but if you go with 4 different teachers are teaching that class(2 groups of 2) then answer c would be correct. I think C SHOULD say at least 2 teachers will be getting a raise. but thats just my opinion. :) joe [EMAIL PROTECTED] 08/21/01 12:25PM 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: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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).
RE: How do they get the answer?
Title: RE: How do they get the answer? My thoughts are Typical OCP question. a) Could be the answer depending on if both the subjects are taught by the same 2 teachers b) Cannot be the answer because only 2 subjects are mentioned (102,105) c) Could be the answer if the 2 subjects are taught by 4 different teachers (not it cannot be more than 4 therefor the 'at least 4' is misleading d) If a syntax error did occur you would correct and run again so why you should fail the OCP question for that reason is bizarre anyway. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 21 August 01 17:26 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: NameNull? Type IDNOT 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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: How do they get the answer?
I think you're being tricked by the question. If each subject is taught by two or more teachers, and you're updating the salaries of all teachers teaching two subjects, 2 x (2+?) = 4 Brian [EMAIL PROTECTED] wrote: 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: NameNull? Type ID NOT NULLNUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULLNUMBER(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). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw 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).
RE: How do they get the answer?
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: NameNull? Type ID NOT NULLNUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULLNUMBER(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).
RE: How do they get the answer?
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 IDNOT NULLNUMBER(9) SALARYNUMBER (7,2) SUBJECT_IDNOT NULLNUMBER(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).
Re: How do they get the answer?
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: [EMAIL PROTECTED] Date: 2001/08/21 Tue PM 12:25:54 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 IDNOT NULLNUMBER(9) SALARYNUMBER (7,2) SUBJECT_IDNOT NULLNUMBER(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: Jon Walthour 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).
Re: How do they get the answer?
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 [EMAIL PROTECTED] 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: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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).
RE: How do they get the answer?
Title: RE: How do they get the answer? Ken, after reading through the quesiton and thinking it through I arrived at the answer they give. They are trying to trick you into choosing syntax error. You'll find questions similar to this on the exams. Lara Croft. Certified Tomb Raider and DBA. Ft. Lauderdale, FL, USA -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 12:26 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: NameNull? Type IDNOT 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).
RE: How do they get the answer?
What if there are only two teachers among all teachers that teach both the (specified) subjects ? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -Original Message- Sent: Tuesday, August 21, 2001 12:52 PM To: Multiple recipients of list ORACLE-L 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 *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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).
Re: How do they get the answer?
At least 2 teachers per subject and the where clause has 2 subjects in the query. 2 teachers X 2 subjects= 4 minimum. ROR mô¿ôm [EMAIL PROTECTED] 08/21/01 12:25PM 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: NameNull? Type ID NOT NULLNUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULLNUMBER(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: Ron Rogers 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).
Re: How do they get the answer?
The answer must be AT LEAST 2 Teachers . Because lets say two teachers Rick and Susan. Susan gives the subjects 102 and 105 Rick gives the subjects 102 and 105 Nobody else gives these subjects. This proves that at least two teachers are given salary rise. bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 8:03 PM 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: Bunyamin K. Karadeniz 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).
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 [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 NULLNUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULLNUMBER(3) SUBJECT_DESCRIPTIONVARCHAR2(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).
Re: How do they get the answer?
It's possible, but not the only possibility. Therefore you can't answer A. And if you're not certain, you can't answer the question. Because this is the Oracle OCP exam. The thing that you've studied night and day for. Everything you learned in the two-night class preparing you for database administration and nuclear physics. This is crunch time, baby - right or wrong? You make the call. Pressure's on. Which will it be? What if this is the question that will put me under that passing grade. A or C? A or C? Which will it be? What will I do? You want the truth? You want the truth? You can't handle the truth! I'm heading back to the espresso machine now... Brian JOE TESTA wrote: 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 >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > Date: 2001/08/21 Tue PM 12:25:54 EDT > To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> > 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: Jon Walthour 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). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | --
Re: How do they get the answer?
This is a poorly written question. I would guess that since it is the teacher table the assumption is that the ID is unique, even a primary key (it is not null), but none of this is stated so it doesn't have to be the case. Although I can't see it making any sense to repeat the salary (if indeed this is the salary for the teacher rather than the course), if a teacher can be in more than once that block could be used an example of an update not doing what was expected. The update is done on subject_id and it is the record with that subject_id. If a teacher is teaching more than one course and the salary if for the teacher rather than the course, we end up with the possibility of different salaries for the same teacher and if the teacher happened to be teaching both and therefore was to get two raises what happens but those two records are now consistent at the wrong value. Of course with what info is given in the question there are other possibilities for what the table really represents and what the PL/SQL block is supposed to do. I would think an essay question on what is going on would be more revealing of the individual's knowledge than a flawed multiple guess question. I don't think I have ever heard of it for anything other than true-false but justifying the selection might make it a little more useful. Pat Examine the structure of the TEACHER table: Name Null? Type IDNOT NULLNUMBER(9) SALARYNUMBER (7,2) SUBJECT_IDNOT NULLNUMBER(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: Pat Hildebrand 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).
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: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: JOE TESTA [SMTP:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Date: 2001/08/21 Tue PM 12:25:54 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: NameNull?Type IDNOT NULLNUMBER(9) SALARYNUMBER (7,2) SUBJECT_IDNOT NULLNUMBER(3) SUBJECT_DESCRIPTIONVARCHAR2(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_raisenumber := 1.10; BEGIN UPDATEteacher SETsalary = salary * 1.10 WHEREsubject_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: [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 http://www.orafaq.com -- Author: Jon Walthour 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: How do they get the answer?
I agree with Joe, the correct answer is two. It doesn't state that a teacher can only teach one subject so the same two teachers can teach both subjects. Ialso agree with everyone that mentioned that this is a crappy question. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Tuesday, August 21, 2001 2:52 PMTo: Multiple recipients of list ORACLE-LSubject: 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Date: 2001/08/21 Tue PM 12:25:54 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: Jon Walthour INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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).
RE: How do they get the answer?
What if there are no subject_ids of either 102 or 105 or both in the table? I'd say it's a case of not enough info (for us that is, not enough thought on the part of whoever made it up but then they didn't ask the list did they ;-) ). This is why I dislike word problems. Linda -Original Message- Sent: Tuesday, August 21, 2001 12:52 PM To: Multiple recipients of list ORACLE-L 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Date: 2001/08/21 Tue PM 12:25:54 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: NameNull?Type IDNOT NULLNUMBER(9) SALARYNUMBER (7,2) SUBJECT_IDNOT NULLNUMBER(3) SUBJECT_DESCRIPTIONVARCHAR2(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_raisenumber := 1.10; BEGIN UPDATEteacher SETsalary = salary * 1.10 WHEREsubject_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: [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 http://www.orafaq.com -- Author: Jon Walthour 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: Seley, Linda 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).
Re: How do they get the answer?
It could be anywhere from 0 to more then 4 teachers receiving increase, depending on whether there are teacher/teachers teaching both subjects, and on whether one (or both subjects) with those IDs (102, 105) exists or not exists in the table. Extreme case (0 teachers receiving increase), when neither subject_id exists in the table. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 12:57 PM I think you're being tricked by the question. If each subject is taught by two or more teachers, and you're updating the salaries of all teachers teaching two subjects, 2 x (2+?) = 4 Brian [EMAIL PROTECTED] wrote: 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: NameNull? Type ID NOT NULLNUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULLNUMBER(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). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw 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: Igor Neyman 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).
RE: How do they get the answer?
They can't give any raises this year. They have to hire a data modeler using those monies. There were at least four raises that could be used for this purpose. -Original Message-From: Brian McGraw [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 3:26 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How do they get the answer?It's possible, but not the only possibility. Therefore you can't answer A. And if you're not certain, you can't answer the question. Because this is the Oracle OCP exam. The thing that you've studied night and day for. Everything you learned in the two-night class preparing you for database administration and nuclear physics. This is crunch time, baby - right or wrong? You make the call. Pressure's on. Which will it be? What if this is the question that will put me under that passing grade. A or C? A or C? Which will it be? What will I do? You want the truth? You want the truth? You can't handle the truth! I'm heading back to the espresso machine now... Brian JOE TESTA wrote: 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Date: 2001/08/21 Tue PM 12:25:54 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: Jon Walthour 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). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | --
Re: How do they get the answer?
well we know the answer is C, but its the most correct out of the 4, not necessarily the ultimate correct answer. joe [EMAIL PROTECTED] 08/21/01 03:25PM It's possible, but not the only possibility. Therefore you can't answer A. And if you're not certain, you can't answer the question. Because this is the Oracle OCP exam. The thing that you've studied night and day for. Everything you learned in the two-night class preparing you for database administration and nuclear physics. This is crunch time, baby - right or wrong? You make the call. Pressure's on. Which will it be? What if this is the question that will put me under that passing grade. A or C? A or C? Which will it be? What will I do? You want the truth? You want the truth? You can't handle the truth! I'm heading back to the espresso machine now... Brian JOE TESTA wrote: 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Date: 2001/08/21 Tue PM 12:25:54 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: Jon Walthour 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). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | --
Re: How do they get the answer?
The structure of the table indicates to me that they began with the assumption that each teacher would only be teaching one subject. At 10:52 AM 8/21/01 -0800, you wrote: 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Date: 2001/08/21 Tue PM 12:25:54 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: Jon Walthour 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).
RE: How do they get the answer?
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.comcc: 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 NULLNUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULLNUMBER(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_raisenumber := 1.10; BEGIN UPDATE teacher SET salary = salary * 1.10 WHEREsubject_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
Re: How do they get the answer?
Each subject has 2 teachers. By limiting the update by 2 subject_id's, you guarantee that 4 teachers will get a raise. Actually, this is poor SQL if a teacher teaches more than one subject (but that's not part of the problem). Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: 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: NameNull? Type ID NOT NULLNUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULLNUMBER(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) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer 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).