More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
SQL Server DBA - Solve the FizzBuzz problem with SQL code.
Here’s a quote of the FizzBuzz problem:
Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are multiples of both three and five print “FizzBuzz”.
Challenge the DBA to do this on a whiteboard with pseudocode. The code doesn’t have to be perfect syntax, but we’re looking for the ability to solve this problem clearly and quickly.
(Continued on next question...)