Dave62 (1/18/2013)

---

Mighty (1/18/2013)

---

Dave62 (1/18/2013)... I was interested and curious about why the message (1 row(s) affected) was being returned. It would appear that some have confirmed my suspicion that...

Dave62 (1/18/2013)

---

No, I don't think there is any "relevance" so to speak. Some questions are just trivia.

I...

okbangas (1/15/2013)

---

As far as I understand it, there is something missing from the explanation. If we assume that only what's written in the scenario has happened, the scenario is...

The questions seemed straight forward, and the outcome should have been 0 results (according to me) since it seemed to say some like [font="Courier New"]WHERE @x LIKE '[aeiou]' AND @x...

This would have been a basic question, if it would have had two create table statements to accompany it. Now it was unclear, and left much room for assumptions, which...

@call.copse

I know it is a bit picky, but in the MSDN article they even explained it in a more detailed way with base view, and derived view, etc.

I don't...

I was doubting on the second option, since it says "inherits" (like in the MSDN article). For me a view that display rows from another view, doesn't inherit rows from...

I didn't like the way the question was asked.

I answered correctly, but didn't even consider the number of rows, but just because @Exceptions wasn't been declared in the query statement...

I agree with some of the others: I COULD have been a good question.

How could we possible know if the incorrect "ROOT" was put there as part of the test,...

I might overlook something, but aren't option 2 and 3 the same?

John Mitchell-245523 (6/8/2012)

---

I got this right, but I'm still a little confused. Am I correct in thinking that what is being tested here is knowledge of the IGNORE_DUP_KEY setting...

I would like to point out the fact that the select statement would have returned the same results, even if the WITH (IGNORE_DUP_KEY = ON) would not have been specified...

Strange that the discussion is about the fact that the explanation is incorrect, and that no one says that the anwers is incorrect. The correct answer is 0, and not...

Learnt something new from the question, which was good.

Selected the only one correct answer, leaving out the other "correct" option. No points.

I agree on the opinion of quite a few others that the question is not clear enough, and that the answer is incorrect (even though I answered it "correctly").

You can...