SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

IBM,

6 10395

create index a on employee(dno) In this,which index was created?

2 4780

How will u get 5 years back record?

5 9601

What is a materialized view?

3 8487

What is MSDE?

2 4889

How can you see what type of locks used?

1 4871

What is transcation?Plz give One example?

2 5082

Plz tell about backup&recovery?

3 5324

How to find the date and time of last updated table?

3 17607

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 10068

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

IBM,

8 10855

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

ADP, Satyam, Tech Mahindra,

7 13846

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

Wipro,

5 11814

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 4523

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 4366

Un-Answered Questions { SQL Server }

What are sub reports?

201

How to modify an existing user defined function?

1103

Do you know what are various aggregate functions that are available?

1125

How to drop an existing schema in ms sql server?

1101

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1005

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1010

Explain external key management in sql server 2008

888

What is instead of dml trigger?

1002

What are 3 ways to get a count of the number of records in a table?

1078

What is policy management?

996

Define primary key?

1138

What is executereader?

952

What is key set driven?

957

Explain the architecture of ms sql reporting service?

921

How to use union to merge outputs from two queries together in ms sql server?

1069

For More Un-Answered { SQL Server } Questions Click Here