True or false, Report Builder supports user defi

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

(Continued from previous question...)

True or false, Report Builder supports user defined run time parameters?

Answer
True

Explanation
Absolutely true. Users can define any portion of a filter to be a run time prompt, letting other users easily change the filter as needed. Not only is it easy to set up, Report Builder automatically populates a list of all possible choices based on the column being filtered.

(Continued on next question...)

Other Job Interview Questions

• You cannot execute procedures on the 2005 server. Why not?
• What's the difference between a server login and a database user?
• What security role should you assign them?
• Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?
• Can you re-associate the application with the same SSNS instance?
• To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• You have specified that a SQL Server 2005 login must respect the password policy on a Windows XP host. Which of the following are valid passwords for the user Kendall?
• You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• More...