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?

1040

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

872

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?

1280

How to find the second highest salary of an employee?

1124

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

1125

How to make a remote connection in a database?

935

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

1190

Explain the first normal form(1nf)?

979

What is a non-clustered index?

957

Explain the relational database management system (rdbms)?

1037

What is checkpoint in sql server?

1076

What is normalization and denormalization in sql server?

959

Explain “not null constraint” in sql server?

971

Explain indexing and what are the advantages of it?

974

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

1157

Un-Answered Questions { SQL Server }

How do you use a subquery to find records that exist in one table and do not exist in another?

1002

Explain cursor as data base object?

990

How can you start sql server in different modes?

934

Define inner join in sql server joins?

999

what are user defined datatypes? : Sql server database administration

936

Does sql server use t sql?

974

Explain what are commit and rollback in sql?

874

What is the name of the system variable that returns the number of rows affected by a SQL statement?

979

Tell me what is de-normalization and what are some of the examples of it?

972

What is sql collation?

1146

what's the information that can be stored inside a bit column? : Sql server database administration

981

whats the maximum size of view state??

2153

What happens to a statement batch if there is a compilation error?

914

What are different types of table joins?

968

Explain mixed authentication mode of sql server?

997

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