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?

1021

Mention the different types of triggers?

1117

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?

968

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 to sort the query output with order by clauses in ms sql server?

1035

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1015

What are the types of normalization?

1031

How to get the number of affected rows?

1006

Can truncate be rolled back?

946

Difference between drill down and drill through report.

956

Mention the differences between substr and charindex in sql server.

1050

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1024

How do I create a stored procedure in sql server?

1034

what is a self join? : Sql server database administration

1041

What happens if ntwdblib.dll is missing on your machine?

1144

Explain about extended stored procedure?

940

Explain what is the function of sql server agent windows service?

994

What is a trace frag?

1085

What is difference statement and preparedstatement?

979

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