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

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 3877

one table has four field id,name,design,salary. i have to find maximum salary .

6 7954

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 10726

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 5036

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

Teledata,

6 9952

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 24051

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 9350

What value could be assigned to Varchar Type?

3 6055

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 5645

What types of integrity are enforced by a foreign-key constraint

1 4349

What are the main control-of-flow T-SQL constructs?

1 4897

What are the two virtual tables SQL Server maintains for triggers?

3 8620

What does the INSTEAD OF trigger do?

3 7765

What are explicit and implicit transactions?

BirlaSoft,

4 22308

What are the two types of concurrency?

4 8249

Un-Answered Questions { SQL Server }

What are a database and a data warehouse?

1078

What is update locks?

941

How do I know if localdb is running?

1001

What is named query? : sql server analysis services, ssas

1006

What is the command used to check locks in microsoft sql server?

1106

What are different backups available in sql server?

1160

List down some advantages of sql stored procedure?

1019

What is the purpose of object explorer and its features? : sql server management studio

1280

Give main differences between "Truncate" and "Delete".

1158

Why we use the openxml clause?

1059

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1173

What are different types of join?

1378

What are out-of-range errors with date and time literals?

1099

what do you understand by change data capture?

1084

What is ms sql server service broker?

1048

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