O yes, that's true. I did not recall to enable trace flag as foglight does that stuff and for that no need to enable the trace flag. Was trying to...

I simulated a deadlock situation. I found the below error in the other screen as SQL chosen tjhat query as victim. I did not enable any trace flag.

Msg 1205, Level...

Got 2 marks. Simple one to start my day.

Good Q. Scored 1 mark.

Fairely simple question. Gained 1 mark.

why not CURRENT_TIMESTAMP??

But it is being asked to run the entire script at a single one. I'm sure this portion of the string was excess

good one

The question wordings were little confusing to me. But scored 1 mark.

readpipe and makepipe utilities were deprecated long back.

Got easy marks.

why not error level = 14 and state =1 ??

Very Nice Question. I liked it.

good question on datatype conversion practices.

'TRUNCATE does not fire triggers, but DELETE does." This option does not seem like correct, instead it should be that "Truncate doesn't fire delete triggers." Rest all options seem to...