Query

  • Comments posted to this topic are about the item Query

  • mmm...

    isn't correct!

    "month(dob) in (1,2,3,4,5,8)"

    What is "dob"???? 😉

    if in the secord option, call the date "join_name":

    datename(m,join_date) like '%a%'

    and, the second option is right only in english version

    give me my points!!! 😛

    Greetings From Argentina!Pablo

  • I am pretty upset about the fact that the questions posted doesn't seem to be appropraitely matching with the options specified in the list of answers.

    I don't seem to understand what is dob column in the answer option.:hehe:

  • I agree with Pablo! And yes, I want my point too!

    [font="Comic Sans MS"]Vic[/font]
    www.vicrauch.com

  • Yeah, 'dob? WTF is 'dob'? Commonly it's short for 'date of birth', which has nothing to do with when an employee joined a company.



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


  • dob ?? 😀

    what is the 'dob' of the author of this question ?:hehe:

  • Apart from the fact that I dont know about the elusive 'dob' as well, I am also wondering that the explaination that was given in the right answer "each of the months have one 'a' atleast once" will only be right if the ENTIRE name of the month is taken into consideration.

    This will fail if only "Feb" as a string or month name is passed.

  • The question ask only for those employees Who joined in the month of Jan, Feb, March, April, May, Aug from table employee having a field of join_date where as the correct answers tells that "month(dob) in (1,2,3,4,5,8)" will also give the required data which is not correct. (normally "dob" denotes to Date of Birth)

    The other answer " datename(m,join_date) like '%a%' " is also not correct as it will not give the list of employees who joined in the month of FEB

    Since both " month(dob) in (1,2,3,4,5,8), datename(m,join_date) like '%a%' " answer are not correct, the last answer "Not in List" is the correct answer.

    I nee my points.


    Warm Regards,

    Jignesh Mehta

  • The question asks for join_date, not dob, so first answer is incorrect.

    datename(m,) returns full name of month, which gives correct result for few languages, but not all, so it's also incorrect, resulting in "not in list" as the only correct answer.

    Yet another poor QoD. They're meant to be fun, not to upset participants.

  • Yeah! I agree with all of the above!

    I do thank you for all the questions that are insightful (and correct). It's an ego bruising event when you get something wrong so these one's really suck!

    How can something that was not included in the question be referenced as a correct answer (dob) - even if it was supposed to mean date_of_beginning!

    Better luck tomorrow!

  • Jignesh Mehta (4/6/2008)


    The question ask only for those employees Who joined in the month of Jan, Feb, March, April, May, Aug from table employee having a field of join_date where as the correct answers tells that "month(dob) in (1,2,3,4,5,8)" will also give the required data which is not correct. (normally "dob" denotes to Date of Birth)

    The other answer " datename(m,join_date) like '%a%' " is also not correct as it will not give the list of employees who joined in the month of FEB

    Since both " month(dob) in (1,2,3,4,5,8), datename(m,join_date) like '%a%' " answer are not correct, the last answer "Not in List" is the correct answer.

    I nee my points.

    datename(m,..) will return "February" for the FEB dates, so like '%a%' will return it.

    see here

    The problem is with the typo "dob"...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • The QotD seems to be getting a lot of mistakes lately. I didn't pick A because of the "dob" field, and didn't pick B as well from not thinking well enough. So I pick C. Hence half is my mistake, so I'm happy to forego my points. But still, the question could have been better.


    Urbis, an urban transformation company

  • I couldn't believe that someone need to use "datename(m,join_date) like '%a%'" to extract rows of Jan, Feb, March, April, May, Aug. :w00t:

  • Hi

    So what do we do when the questions go wrong. Can the points be given to people who have chosen the "RIGHT" answer.

    "Keep Trying"

  • The first option specifies a column called dob.

    This was not mentioned in the question therefore I believe I answered correctly.

    Please credit me with my points

Viewing 15 posts - 1 through 15 (of 95 total)

You must be logged in to reply to this topic. Login to reply