RE: How do they get the answer?

o > 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

RE: How do they get the answer?

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

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 ta

RE: How do they get the answer?

Sent by: Subject: RE: How do they get the answer?

Re: How do they get the answer?

ach 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 t

Re: How do they get the answer?

; > 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 g

RE: How do they get the answer?

tiple 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 yo

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 neit

RE: How do they get the answer?

achers 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

RE: How do they get the answer?

ECTED] [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

RE: How do they get the answer?

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 g

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 t

Re: How do they get the answer?

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-T

RE: How do they get the answer?

TECTED]> >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 >equ

Re: How do they get the answer?

ry 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 > >

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

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 ref

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 an

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 soft

Re: How do they get the answer?

TED] > 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. &

RE: How do they get the answer?

-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

Re[2]: How do they get the answer?

I think someone had difficulties with word problems in Math class. Gotcha again!! Dick Goulet Reply Separator Author: "Brian McGraw" <[EMAIL PROTECTED]> Date: 8/21/2001 8:57 AM I think you're being tricked by the question. If each subject is taugh

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).

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

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 TEA

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

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