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?

1030

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

1125

What security features are available for stored procedure?

1080

What is stored procedures?

1112

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

1066

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

979

Explain syntax for viewing, dropping and disabling triggers?

1000

Explain triggers?

1066

How to apply cascading referential integrity in place of triggers?

1096

How to invoke a trigger on demand?

1155

What is ms sql server triggers?

1075

What are the instances when triggers are appropriate?

1022

How many triggers you can have on a table?

1035

Determine how to use the inserted and deleted pseudo tables?

1046

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

920

Un-Answered Questions { SQL Server }

What is data block and how to define data block size?

1087

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

1283

What is the difference between cartesian product and cross join?

906

What is code near application topology?

283

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1270

What program is used to store the data source file?

1010

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

997

Explain different forms of normalization?

1004

What is nonclustered index on computed columns?

1000

What are the advantages of log shipping?

1041

Does partitioning help performance?

997

Explain sql server authentication modes?

1190

What is sql server used for?

1101

What type of locking occurs during the snapshot generation? : sql server replication

1377

What are various aggregate functions that are available?

1048

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