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

Explain what is dbcc?

1069

Explain in brief how sql server enhances scalability of the database system?

1029

Explain what is row_number function?

1085

Tell me what is difference between clustered and non clustered index?

984

Explain the phases a transaction has to undergo?

1117

What is sql service broker?

1026

List down some advantages of sql stored procedure?

1019

Do you know what are the properties of the relational tables?

1074

Can you explain various data region available in ssrs with their use?

1026

Tell me in brief how sql server enhances scalability of the database system?

1048

Explain what is log shipping?

1199

What is the significance of null value and why should we avoid permitting null values?

1037

Explain what is the use of custom fields in report?

961

Do you know what is bit data type and whats the information that can be stored inside a bit column?

1001

Can you explain what are various ways to enhance the ssrs report?

1070

Un-Answered Questions { SQL Server }

How to enter binary string literals in ms sql server?

1216

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2813

Call by value and call by reference in procedure and function, with NOCOPY.

1351

What is the difference between Clustered and Non-Clustered Index?

1105

Why use “nolock” in sql server?

1140

How to create a trigger for insert only?

1089

What are secondary xml indexes?

1080

How can I track the changes or identify the latest insert-update-delete from a table?

1015

Differentiate between a having clause and a where clause.

1010

Is it possible to call a stored procedure within a stored procedure?

1030

Mention what are the different types of ssrs reports?

158

Why use stored procedures in sql server?

1064

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1129

How to include text values in sql statements?

1098

Why is replication required on the sql server?

1107

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