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?

911

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

999

What security features are available for stored procedure?

998

What is stored procedures?

971

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

969

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

898

Explain syntax for viewing, dropping and disabling triggers?

907

Explain triggers?

959

How to apply cascading referential integrity in place of triggers?

990

How to invoke a trigger on demand?

1043

What is ms sql server triggers?

966

What are the instances when triggers are appropriate?

942

How many triggers you can have on a table?

953

Determine how to use the inserted and deleted pseudo tables?

947

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

835

Un-Answered Questions { SQL Server }

What is the exact numeric data type in sql?

970

How to find the service pack installed? : sql server database administration

987

What is change tracking in sql server?

955

how can u get last observation in an unknown dataset ?

2399

What is the difference between a local and a global temporary table?

1073

What is row_number function?

951

What happens if null values are involved in datetime operations?

919

What are the new scripting capabilities of ssms? : sql server management studio

1014

Explain what are various ways to enhance the ssrs report?

1001

What is the difference between writing data to mirrored drives versus raid5 drives

877

Explain what is dbcc?

975

What are the encryption mechanisms in sql server?

979

Difference between aggregate functions of sql?

1046

What are sparse columns?

963

What is log cache in sql server?

996

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