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?

1120

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

1100

what do you understand by change data capture?

1019

Mention the different types of triggers?

1114

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.

1024

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 }

What are null values in ms sql server?

1088

Can two different columns be merged into single column? Show practically?

1066

What is triggers in ms sql server?

1118

Explain the xml support sql server extends?

1040

How adventureworkslt tables are related?

926

Explain the relational database management system (rdbms)?

1097

Can the query output be sorted by multiple columns in ms sql server?

980

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1015

What are drillthrough reports?

155

Can we insert data into a view?

1135

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2027

How do you start single user mode in clustered installations?

941

Do you know what is sql injection?

998

what stored procedure can you use to display the current processes? : Sql server administration

1008

How to assign new column names in a view?

918

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