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

What is the significance of master, tempdb and model databases?

1078

Explain alternate key, candidate key and composite key in sql server?

914

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1326

How to find the second highest salary of an employee?

1179

What is the main difference between ‘between’ and ‘in’ condition operators?

1191

How to make a remote connection in a database?

977

Can we write a distributed query and get some data which is located on other server and oracle database?

1231

Explain the first normal form(1nf)?

1025

What is a non-clustered index?

998

Explain the relational database management system (rdbms)?

1098

What is checkpoint in sql server?

1160

What is normalization and denormalization in sql server?

1016

Explain “not null constraint” in sql server?

1029

Explain indexing and what are the advantages of it?

1028

Can we hide the definition of a stored procedure from a use?

1224

Un-Answered Questions { SQL Server }

Explain different types of index?

1057

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1001

Write a SQL query to make a column as unique?

1040

How many columns can we include on clustered index ?

990

What is nonclustered index on computed columns?

960

What is cdc in sql server?

999

What gets stored inside msdb database?

1247

Explain the Ways to improve the performance of a sql azure database?

Can sql servers linked to other servers?

1043

Scalability, Availability, Integration with internet, etc.)?

2878

How to find index size for each index on table?

1003

How will you make an attribute not process? : sql server analysis services, ssas

1089

What are the indexes in sql server?

1115

What is the difference between a clustered index and a non-clustered index?

991

How to round a numeric value to a specific precision?

1075

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