DBA > Interview Resource

Microsoft SQL Server FAQs

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41 

(Continued from previous part...)

When you install SQL Server 2005 and create a new database, is a Database Master Key created?

Answer
No
Explanation
A database master key is not created when a database is created. It must be created by an administrator.


What does the DEALLOCATE statement do in SQL Server 2005?

Answer
Remove a reference to a cursor.
Explanation
This statement is used to remove cursor references. If this is the last reference being removed, the cursor's resources are released.


Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?

Answer
Have users save the RDL files locally and check into source control using a source control utility, or write code to script them out each night and check them into source control
Explanation
Users can do faux source control by just saving copies of their RDL files locally before they make a change. Beyond that, you either teach them how to use a source control utility or you write a utility you can run on a schedule.


Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins

Answer
Objects from unsigned CLR assemblies with EXTERNAL_ACCESS or UNSAFE permissions

Explanation
In order to execute objects from CLR assemblies with EXTERNAL_ACCESS or UNSAFE permissions, the assemby must either be signed with a key pair or the database hosting the assembly must have the TRUSTWORTHY database property set to ON. Executing the other answers is essentially controlled by permissions. Setting the TRUSTWORTHY database property to ON also allows you to use the EXECUTE AS clause to allow impersonation outside the scope of the database within the instance but this was not one of the answers.


What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?

Answer
Report Builder

Explanation
Report Builder is bundled as part of Reporting Services 2005 and is targeted at end users needing to build ad hoc reports. BI Design Studio could be used, but typically requires more time and experience to use than the average end user will be willing to invest.

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41