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

What is extended stored procedures?

1024

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

1120

What security features are available for stored procedure?

1077

What is stored procedures?

1110

In what three ways is the return statement used in a stored procedure?

1062

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

Explain syntax for viewing, dropping and disabling triggers?

996

Explain triggers?

1063

How to apply cascading referential integrity in place of triggers?

1090

How to invoke a trigger on demand?

1150

What is ms sql server triggers?

1070

What are the instances when triggers are appropriate?

1019

How many triggers you can have on a table?

1033

Determine how to use the inserted and deleted pseudo tables?

1043

Explain trigger classes i.e. Instead of and after trigger?

918

Un-Answered Questions { SQL Server }

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1036

What are data regions?

140

Explain primary key and foreign key constraints?

1089

What function does a database engine serve in the sql server?

1081

What is “asynchronous” communication in sql server service broker?

1080

How do I open port 1433?

987

What happens if null values are involved in arithmetic operations?

1049

Can you please differentiate between a primary key and a unique key?

1049

How to return the second 5 rows in ms sql server?

1107

How would you choose between a clustered and a non-clustered index?

1019

What are number line correlation administrators will use while working with a subquery?

1217

Determine how to use the inserted and deleted pseudo tables?

1043

What is checkpoint in sql server?

1215

Can we write ddl in trigger?

969

how many clustered indexes can be created on a table? : Sql server database administration

1223

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