|
Question |
Rating |
View Answer |
|
What is the difference between weak entity set & strong entity set? |
|
View Answer |
|
How will you copy the structure of a table without copying the data? |
|
View Answer |
|
When discussing image support in Report Builder, which of the following is the most accurate statement? |
|
View Answer |
|
You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries. It was recommended that you drop the indexes on the table before the load and then rebuild them after the load is complete. Is this something you would do? |
|
View Answer |
|
What is a "trigger"? |
|
View Answer |
|
On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005? |
|
View Answer |
|
What algorithm is used to encrypt the Database Master Key when it is created? |
|
View Answer |
|
How many users can be added to an application role in SQL Server 2005? |
|
View Answer |
|
Give some examples of Analytical functions? |
|
View Answer |
|
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? |
|
View Answer |
|
Which of the following is not an allocation unit in SQL Server 2005? |
|
View Answer |
|
What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005? |
|
View Answer |
|
Explain about the command line tool SQLCMD? |
|
View Answer |
|
What is the Disadvantage of StoredProcedure? |
|
View Answer |
|
What is the recommended way to send mail from SQLAgent in SQL Server 2005? |
|
View Answer |
|
Where does Profiler store its temporary data in SQL Server 2005? |
|
View Answer |
|
Explain about protocol layer present in SQL server? |
|
View Answer |
|
Explain about thread and memory management process of SQL? |
|
View Answer |
|
What is the recommended way to send mail from SQLAgent in SQL Server 2005? |
|
View Answer |
|
When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify? |
|
View Answer |