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

How can we remove orphan records from a table?

980

What do you mean by recursive stored procedure?

941

What structure can you implement for the database to speed up table reads?

1193

What are the acid properties?

1000

Explain different types of index?

1043

What are user-defined functions (udfs) in sql server?

983

Explain how many normalization forms?

1024

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1138

Explain boyce and codd normal form(bcnf)?

934

How important do you consider cursors or while loops for a transactional database?

960

In what version of sql server were synonyms released?

936

What are the aggregate and scalar functions?

1055

What is the need for group functions in sql?

1078

What is the difference between varchar and varchar types?

1069

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

987

Un-Answered Questions { SQL Server }

How do you delete duplicate records in sql server?

1047

Which are the third-party tools used in sql server and why would you use them?

895

How to write a query with an inner join in ms sql server?

1040

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2336

What are the characteristics of modern DBMS?

1085

How to use values from other tables in update statements in ms sql server?

1107

Name three of the features managed by the surface area configuration tool? : sql server security

986

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1074

Explain triggers?

999

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1089

What is resultset concur_updatable?

1015

What is difference between materialized view and view?

905

What are the different types of collation sensitivity?

1115

What is blocking and how would you troubleshoot it? : sql server database administration

1041

Can group by and orderby be used together?

1005

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