casinos

Archive for January 13th, 2012

SQL Interview Quiz Part I January 13th, 2012

Vinod Kumar

I have been helping my co-author of book – “SQL Server Interview Questions and Answers” – Pinal Dave over his blog for a unique contest. And the SQL Quiz has been up and running for the past 13 days and we are excited to see some great response from the folks out there. Keep those flowing :). It is not late yet, let me recap what all to watch out for the first 10 Quizzes till date. Exciting prizes awaits, so don’t miss the opportunity.

Day 1: It is about ANSI-Isolation Levels Question. Hint over Pinal’s Blog (here)

Day 2: Quiz around various kinds of Triggers. Hint over Pinal’s Blog (here)

Day 3: Identity and behaviors inside SQL Server. Hint over Pinal’s Blog (here)

Day 4: The tale of using WHERE clause inside SQL Server. Hint over Pinal’s Blog (here)

Day 5: Locking and Blocking with SQL Server. Hint over Pinal’s Blog (here)

Day 6: Collation and Collation Sensitivity with SQL. Hint over Pinal’s Blog (here)

Day 7: Restrictions with Indexed Views. Hint over Pinal’s Blog (here)

Day 8: RANKING functions with SQL Server. Hints over Pinal’s Blog (here)

Day 9: Blocking and Locking with SQL Server Quiz. Hint over Pinal’s Blog (here)

Day 10: OUTPUT Clause with SQL Server DML statements Quiz. Hint over Pinal’s Blog (here)

Each of the quiz questions are quite easy to solve if you get a chance to see the hints we have provided. In fact, they are giveaways once you read the hint. Seriously, believe me. So much of fun to pick some of these fine prints when working with SQL Server.

Lesser known fact – “SQL Server Interview Questions and Answers” book is over Kindle. These questions are surely discussed over our book, so we think it is making us think more and expand on the basics we discussed over the book.

Feel free to take part in the quiz folks and pass me your feedbacks.

Continue reading...