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 3790

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

6 7689

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

2 10598

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 4892

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

Teledata,

6 9692

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 23866

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 9192

What value could be assigned to Varchar Type?

3 5905

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

3 5511

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

1 4255

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

1 4810

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

3 8475

What does the INSTEAD OF trigger do?

3 7620

What are explicit and implicit transactions?

BirlaSoft,

4 22100

What are the two types of concurrency?

4 8072

Un-Answered Questions { SQL Server }

What are views used for?

1011

Write a code to select distinct records without using the DISTINCT keyword.

1111

Differentiate between truncate vs delete in mssql?

1078

How to disable triggers using "disable trigger"?

1051

What are the types of sql server?

1044

What are the components of sql server service broker?

1011

How to insert stored procedure result into temporary table?

1013

Explain what is raid and what are different types of raid levels?

1018

Does the unique constraint create an index?

1054

What is difference between createstatement and preparedstatement?

1084

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1074

What do you know about system database? : SQL Server Architecture

978

What happens when the SQL Azure database reaches Max Size?

111

Can you pass expressions to stored procedure parameters?

1023

What is bit data type? What's the information that can be stored inside a bit column?

913

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