Which of the following choices show the three re

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Which of the following choices show the three report formats supported by Report Builder

Answer
Table, Matrix, Chart

Explanation
Report Builder can build a report formatted as a table, chart, or matrix (cross tab), but only ONE can be used in any given report.

(Continued on next question...)

Other Job Interview Questions

• Which of the following is not an allocation unit in SQL Server 2005?
• What is an example of hardware partitioning?
• What is the best way to have your junior DBA do this?
• You cannot execute procedures on the 2005 server. Why not?
• The Sort component in SQL Server 2005 Integration Services is what type of component?
• Which key does the OPEN MASTER KEY statement open?
• What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?
• What does @@textsize return?
• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• What does the function ORIGINAL_LOGIN return in SQL Server 2005?
• More...