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 10365

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

2 4772

How will u get 5 years back record?

5 9582

What is a materialized view?

3 8475

What is MSDE?

2 4882

How can you see what type of locks used?

1 4868

What is transcation?Plz give One example?

2 5067

Plz tell about backup&recovery?

3 5324

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

3 17602

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 10062

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 10830

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 13815

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

Wipro,

5 11786

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

1 4516

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

2 4361

Un-Answered Questions { SQL Server }

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1201

How to enter binary string literals in ms sql server?

1150

Other than truncate statement, which other command can by-pass the trigger on the tables?

1129

Explain tables in SQL Azure?

120

write an SQL query to list the employees who joined in the month of January?

1674

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1045

What are the types of joins in sql?

1115

What are trace flags?

1026

Explain “row_number()” in sql server with an example?

994

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1060

Tell about MOM Tool(Microsoft Operator Manager)?

1906

How to include text values in sql statements?

1031

What do you mean by recursive stored procedure?

942

‘Order by’ is not allowed in a view how can you sort information from a view?

1076

What is the architecture of ms sql reporting service?

982

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