Using Report Builder, which of the following sta

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

(Continued from previous question...)

Using Report Builder, which of the following statements is correct about formatting numbers?

Answer
Users can pick from a small number of predefined formats and they have the option to specify a custom format

Explanation
There are give built in formats; general, currency, percentage, two place decimal, and exponent. Users can also define a custom format using a .Net format string.

(Continued on next question...)

Other Job Interview Questions

• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• In Service Broker for SQL Server 2005, you encounter the following setting in one of your queues...
• Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?
• In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• What do you need to do now to ensure you can recover the routes in the event of a disaster?
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• You want to release some memory and reduce SQL Server to 3GB or RAM. How can you do this?
• In Service Broker for SQL Server 2005, you encounter the following setting in one of your queues...
• What message types exist in SQL Server 2005 Service Broker?
• More...