April 5, 2008 at 9:02 pm
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
April 6, 2008 at 2:45 am
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:
April 6, 2008 at 8:05 am
I agree with Pablo! And yes, I want my point too!
[font="Comic Sans MS"]Vic[/font]
www.vicrauch.com
April 6, 2008 at 2:09 pm
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.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
April 6, 2008 at 8:12 pm
dob ?? 😀
what is the 'dob' of the author of this question ?:hehe:
April 6, 2008 at 8:45 pm
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.
April 6, 2008 at 11:04 pm
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.
April 7, 2008 at 12:55 am
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.
April 7, 2008 at 1:06 am
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!
April 7, 2008 at 1:12 am
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
April 7, 2008 at 1:18 am
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.
April 7, 2008 at 1:25 am
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:
April 7, 2008 at 2:09 am
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"
April 7, 2008 at 2:13 am
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