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?

986

What do you mean by recursive stored procedure?

952

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

1199

What are the acid properties?

1005

Explain different types of index?

1064

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

990

Explain how many normalization forms?

1037

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

1148

Explain boyce and codd normal form(bcnf)?

958

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

966

In what version of sql server were synonyms released?

942

What are the aggregate and scalar functions?

1069

What is the need for group functions in sql?

1083

What is the difference between varchar and varchar types?

1071

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

992

Un-Answered Questions { SQL Server }

How we can compare two database data?

948

What is difference in performance between insert top (n) into table and using top with insert?

1046

What is a coalesce function?

1195

What are different types of replication in sql server?

1087

how many bits ip address consist of? : Sql server database administration

900

Define magic tables in sql server?

1069

How to find out the list schema name and table name for the database?

942

How can we delete a table in sql server?

976

Mention the differences between having and where clause.

1058

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1044

what is the difference between delete table and truncate table commands? : Sql server database administration

1036

Define a cross join?

1028

How to modify existing triggers using "alter trigger"?

1017

What is update_statistics command?

1068

What is model database? : SQL Server Architecture

1133

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