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 10627

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

2 4873

How will u get 5 years back record?

5 9842

What is a materialized view?

3 8633

What is MSDE?

2 5015

How can you see what type of locks used?

1 4973

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 17720

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 10185

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 11101

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 14123

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

Wipro,

5 12061

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

1 4608

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

2 4452

Un-Answered Questions { SQL Server }

How many null values we can have in a unique key field in sql server?

1014

How do I view a stored procedure in sql server query?

986

Explain table valued parameters in sql server? Why tvp used?

1071

How to drop existing indexes in ms sql server?

1133

What is system stored procedures?

1089

what exactly sql injuction.how to overcome.....

2601

How to delete database objects with "drop" statements in ms sql server?

1155

Mention the differences between local and global temporary tables.

1113

Where do you find the default Index fill factor and how to change it?

1120

What are trace flags and mention a few common trace flags used with sql server?

1144

Which are the third-party tools used in sql server and why would you use them?

972

What are the kinds of subquery?

1077

After removing a table from database, what other related objects have to be dropped explicitly?

1108

What is difference between global temporary tables and local temporary tables?

1283

What are the different types of sub-queries?

1092

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