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 name a few encryption mechanisms in sql server?

942

What are subqueries in sql server?

1121

What is the purpose of update statistics and scope_identity() function?

1100

what do you understand by change data capture?

1020

Mention the different types of triggers?

1116

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1163

Explain the properties of subqueries in sql server?

1082

How do you start single user mode in clustered installations?

941

What are the differences between sql server and mysql.

1096

Mention the different types of replication in sql server.

1026

Explain the steps to create and execute a user-defined function in the sql server?

967

What do you understand by triggers?

922

mention different types of relationships in the dbms?

1020

What is the command used to check locks in microsoft sql server?

1044

What do you understand by recursive stored procedure?

930

Un-Answered Questions { SQL Server }

How can you check the level of fragmentation on a table?

1045

Which is the latest version of sql server and when it is released?

1112

What is function of master database?

114

Which are new data types introduced in sql server 2008?

1049

What area unit the various kinds of info compression introduced in sql server 2008?

1091

What are the tools available in market as an alternative to sql server reporting services?

131

What is the purpose of the tempdb database?

1000

List the different types of collation sensitivities in sql server?

1044

What is truncate table?

939

What is application role in sql server database security? : sql server security

1057

can you implement data mining in SSRS?

148

What is a non equi join?

981

Which command is used for user defined error messages?

1060

Do you know what are different types of replication in sql server?

1099

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1010

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