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 10624

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

2 4871

How will u get 5 years back record?

5 9839

What is a materialized view?

3 8631

What is MSDE?

2 5015

How can you see what type of locks used?

1 4969

What is transcation?Plz give One example?

2 5173

Plz tell about backup&recovery?

3 5441

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

3 17719

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 10183

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 11099

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 14111

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

Wipro,

5 12059

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

1 4607

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

2 4447

Un-Answered Questions { SQL Server }

Why should you use or avoid select * statements?

1079

How to join two tables in a single query in ms sql server?

1062

Do you know how to send email from database?

1053

What is difference between stored procedure and user defined function?

1172

How to remove duplicate rows from table except one?

1065

What is exporting and importing utility?

1149

Tell me what is a linked server?

1095

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2583

What do you mean by data integrity?

1131

What are unicode character string data types in ms sql server?

1346

What are the restraints imposed on the table design by a merge replication?

1095

How to transfer data from a cursor to variables with a "fetch" statement?

1148

What is inner join? Explain with an example?

1289

What is the meaning of resultset type_scroll_insensitive?

996

How to create a user name in a database?

1105

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