On Jun 9, 11:25 am, veeru <vikranth....@gmail.com> wrote:
> hi,
> These are some questions i found tricky, please try to answer
> atleast some of questions.
>
> 1.The IF UPDATE(column_name) parameter in a trigger defination will
> return
> TRUE in case of an INSERT statement being executed on the triggered
> table
> --is this statement true/false.
>
> 2. Which of following datatypes is not supported by sql server ?
> a. character
> b. binary
> c. logical
> d. date
> e. numeric
> f. all are supported
>
> 3. A column that allows NULLs requires more space to store a value.
> ---is this statment true/false.
>
> 4. A cursor is a pointer that identifies a specific working row with
> in a
> set.
> ---is this statment true/false.
>
> 5. Study the situation described below and identify the nature of
> relationship /
> Each student can enroll into more than one class. Each class can
> accommodate more than one student.
>
> a. 1 to N
> b. 1 to 1
> c. M to N to 1
> d. M to N
> e. N to 1
> ( what relation of M and N with the question ?)
>
> thanks
> v

>> 5) Reread the question, paying careful attention to the first word.

"Roy Harvey" <roy_harvey@snet.net> wrote in message
news:va7l63h639pfbdf8u6q7ongv8hm3egh77a@4ax.com...
> 1) Write an UPDATE trigger and test it.
>
> 2) Read the documentation.
>
> 3) Read the documentation.
>
> 4) This is the sort of squishy terminology question that makes sense
> only in the context of a course. The answer should be somewhere in
> the course material.
>
> 5) Reread the question, paying careful attention to the first word.
> Then do as the first word of the question directs.
>
> On Fri, 08 Jun 2007 23:25:59 -0700, veeru <vikranth.vss@gmail.com>
> wrote:
>
> >hi,
> > These are some questions i found tricky, please try to answer
> >atleast some of questions.
> >
> >1.The IF UPDATE(column_name) parameter in a trigger defination will
> >return
> >TRUE in case of an INSERT statement being executed on the triggered
> >table
> >--is this statement true/false.
> >
> >
> >2. Which of following datatypes is not supported by sql server ?
> >a. character
> >b. binary
> >c. logical
> >d. date
> >e. numeric
> >f. all are supported
> >
> >
> >3. A column that allows NULLs requires more space to store a value.
> >---is this statment true/false.
> >
> >
> >4. A cursor is a pointer that identifies a specific working row with
> >in a
> >set.
> >---is this statment true/false.
> >
> >
> >5. Study the situation described below and identify the nature of
> >relationship /
> >Each student can enroll into more than one class. Each class can
> >accommodate more than one student.
> >
> >
> >a. 1 to N
> >b. 1 to 1
> >c. M to N to 1
> >d. M to N
> >e. N to 1
> > ( what relation of M and N with the question ?)
> >
> >
> >thanks
> >v

<nospam@dontbotherme.zzz> wrote:

>>> 5) Reread the question, paying careful attention to the first word.
>
>Yes, the word 'The' will lead you to infinite knowledge. :>)
>
>Bob Lehmann