What are different variants of SQL Server 2005?

What are the different recovery models in SQL Server 2005?

You are planning for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols will you use to achieve this goal?

You have currently installed SQL Server 7.0 Standard Edition SP4 and wish to upgrade to SQL Server 2005. Which versions of SQL Server 2005 can you upgrade to?

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?

What is Full Text Search in SQL Server 2005?

It is possible to rename a database and database objects in SQL Server 2005

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

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

What are the requirements to create a CLR based user-defined type?

Which TCP/IP port does SQL Server run on?

If you want to let a member of your technical support staff back up a database without having to grant any other permission to a database or SQL Server instance, to which role should you add the staff member?

Which of the following objects can you use in a check constraint?

You perform a full backup of the Adventure Works database that completes at midnight. Differential backups are scheduled to run every four hours beginning at 04:00. Transaction log backups are scheduled to run every five minutes. What information does the transaction log backup created at 09:15 contain?

One of your users has discovered some malicious updates to your data that occurred the day before at about 2 P.M. how can you return the database to the state it was in just before the update occurred?

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 to solve the problem?

What is bcp utility in SQL Server 2005?

You use the bcp utility to import data during nonworking hours. After importing data into the database, you execute a full backup statement. You need to ensure that the impact on the database during the insert is reduced to a minimum. Which of the following options can help you achieve that?

Which type of index physically orders the rows in a table?