Set - 6

Question 16 :

What does this return?
SELECT USER_NAME() -- Returns Andy
EXECUTE AS TechPreparation

Answer :

The execution context switches can be nested, so changing to TechPreparation, then Steve, then issuing a Revert will return you to the context of TechPreparation. This works in the same manner as a stack.

Question 17 :

In building a PDF report in Reporting Services 2005, images that are originally stored in jpg format are rendered in jpg format. What format are images rendered in if they were stored originally in another format?

Answer :

Images stored originally in formats other than jpg are rendered in png format.

Question 18 :

What does the tablediff utility do?

Answer :

This utility will report the differences in data between two tables.
This utility will report the data differences between two tables. They must be alike in structure and give back the T-SQL to bring the data in the tables to be the same for most datatypes.

Question 19 :

Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.) ?

Answer :

Severity levels 11-16 are correctable by users. Below 11, these are informational warnings and not raised as system errors. Errors above 16 must have an administrator or Microsoft correct.

Question 20 :

What is the granularity in seconds of the timestamp datatype?

Answer :

The timestamp datatype does not store time values.
The answer is the timestamp datatype does not store time values. The better name for this datatype is rowversion, and it is actually a database-wide unique varbinary value. When you have a rowversion column in a table, the value of the rowversion column changes for each modification to each row. The value in the rowversion column is guaranteed to be unique across all tables in the datatype.