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?

931

What do you mean by recursive stored procedure?

882

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

1155

What are the acid properties?

942

Explain different types of index?

985

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

935

Explain how many normalization forms?

968

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

1038

Explain boyce and codd normal form(bcnf)?

891

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

908

In what version of sql server were synonyms released?

905

What are the aggregate and scalar functions?

991

What is the need for group functions in sql?

1007

What is the difference between varchar and varchar types?

1002

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

944

Un-Answered Questions { SQL Server }

what are different types of raid configurations? : Sql server database administration

994

What is the latest version of microsoft sql server?

963

What is the difference between clustered and non-clustered indexes in ms sql server?

937

What is side by side migration in sql server?

1020

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

976

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

983

How to automatically create a log when an exception is being received into SQL Server?

1210

what is a traditional network library for sql servers? : Sql server database administration

893

how many triggers you can have on a table? : Sql server database administration

904

Is it important for a database administrator to understand the operating system and file access?

930

What is sql injection? How to protect against sql injection attack?

941

Comment,Datatypes are unlimited

2016

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

989

What are the security related catalog views? : sql server security

913

When does a workload on SQL Azure get throttled?

129

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