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?

916

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

1002

What security features are available for stored procedure?

999

What is stored procedures?

977

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

970

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

898

Explain syntax for viewing, dropping and disabling triggers?

910

Explain triggers?

960

How to apply cascading referential integrity in place of triggers?

995

How to invoke a trigger on demand?

1049

What is ms sql server triggers?

969

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?

951

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

837

Un-Answered Questions { SQL Server }

Can we add a cpu to sql server?

973

How will you find out if there are expensive SQL statements running or not?

982

What does null mean?

943

When columns are added to existing tables, what do they initially contain?

995

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1007

What kind of problems occurs if we do not implement proper locking strategy?

1373

What stored by the model? : sql server database administration

917

Where can you find the error log information? : sql server database administration

992

Can You Use Data Mining Models In Ssrs?

143

How to connect Azure federated root database and apply federation in entity framework?

107

What is autocommit mode in sql server?

1099

Explain the difference between control flow and data flow?

948

After removing a table from database, what other related objects have to be dropped explicitly?

1013

What is sql sandbox in sql server?

1160

What are wait types?

1035

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