You want to send Personalized Messages to a group of people. Which SQL Server 2005 services would you use?

SQL Profiler tool is used for?

Is it possible to rename a database and database objects in SQL Server 2005?

Which SQL Server 2005 tool helps in running T-SQL queries from command prompt?

Which are the System Databases in SQL Server 2005?

Which objects related to a SQL Server component can you analyze using Upgrade Advisor?

What are the different options in SQL Server 2005 for accessing a Linked Server?

Does SQL Server 2005 support SMTP?

What is Full Text Search in SQL Server 2005?

You are importing data into SQL server 2005 database. You are receiving text files that contain Sales transactions from stores across the city. You need to import the files into Sales Database. What should you do?

You want to access data that is located on two SQL Server 2005 computers. One Server is SQL 1 and the other server is SQL 2. You have permissions to write a stored Procedure on SQL 1 but on SQL 2 you have only permission to select data. You write a stored procedure on SQL 1. The stored procedure accesses SQL 2 by OPENQUERY T-SQL Statement. The query fails. What should you do the solve the problem?

You want to access data that is located on two SQL Server 2005 computers. One Server is SQL 1 and the other server is SQL 2. You have permissions to write a stored Procedure on SQL 1 but on SQL 2 you have only permission to select data. You write a stored procedure on SQL 1. The stored procedure accesses SQL 2 by OPENQUERY T-SQL Statement. The query fails. What should you do the solve the problem?

Which is true for recovery models :

What does database schema do?

Which data type would you use to store up to 2 GB of text data and still be able to query and manipulate it by using standard functions and operators?

Your database has become damaged. Which of the following can be used to determine which backups can be used to restore the database?

You want to move a database from server 1 to server 2. When this operation is going on users should be able to execute their reports without modifying reports. Which method you will use?

Which operation is allowed in a trigger

Which will not allow to drop a table?

Which option restricts changes to data to conform to the select criteria of a view?