|
Question |
Rating |
View Answer |
|
Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report? |
|
View Answer |
|
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? |
|
View Answer |
|
Where can you view the list of server-scoped DDL triggers? |
|
View Answer |
|
What is sql server? |
|
View Answer |
|
You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use? |
|
View Answer |
|
Detail about query optimizer? |
|
View Answer |
|
In which order do you perform an upgrade to SQL Server 2005 for replicated databases? |
|
View Answer |
|
What is the difference between "procedure" and "function"? |
|
View Answer |
|
You have installed a US English SQL Server 2000 instance with the default options, collation, and sorting. What does this return: create table MyTable ( Mychar varchar(20)) go insert Mytable select 'Apple' insert Mytable select 'ant' insert Mytable select 'Ball' go select * from MyTable where Mychar like '[^a]%' |
|
View Answer |
|
Explain real time situation where you would use clustered and Non-clustered Indexes? |
|
View Answer |
|
How many types of system privileges are there, Can we add or delete privileges? |
|
View Answer |
|
You have an old database that needs to run in compatibility mode 65 on your SQL Server 2005 server. Which framework would you use to manage this database programmatically? |
|
View Answer |
|
Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure |
|
View Answer |
|
Which of the following modules within SQL Server 2005 cannot be signed with a digital signature? |
|
View Answer |
|
Explain about SQL server 2005? |
|
View Answer |
|
How to get the list of tables in Sybase? |
|
View Answer |
|
Using Report Builder, which of the following is the best statement about the formatting options for Boolean columns? |
|
View Answer |
|
How can i install a sql server software in a pc? |
|
View Answer |
|
Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options? |
|
View Answer |
|
True or false, Report Builder supports user defined run time parameters? |
|
View Answer |