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

Is candidate a key?

1002

Can foreign key be deleted?

975

Can a table have 2 primary keys?

1030

What are the components of dbms?

995

Can an entity have two primary keys?

1028

How is foreign key related to primary key?

1010

Can foreign key be duplicate?

1116

What are the five major components of a dbms?

961

Can two tables have the same primary key?

1263

What are the properties of primary key?

1014

What do you mean by normalisation?

1099

What are the 3 types of schema?

1171

Can we join two tables without primary key?

1091

What are the types of normalization?

1072

What are the elements of dbms?

1008

Un-Answered Questions { SQL Server }

List some advantages and disadvantages of stored procedure?

1063

whats the maximum size of view state??

2248

How to Insert multiple rows with a single insert statement?

1093

What is collation sensitivity? Explain different types.

1054

Can an automatic recovery be initiated by a user?

1066

how many no of arguments can be passed in procedures and functions

5640

Mention what are the different types of ssrs reports?

158

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1118

What is create statement?

1007

What do you understand by a view?

1044

Explain what is meant by replication of database?

1103

What is the use of for clause?

1162

What is reference section?

1053

Tell me what is use of except clause? How it differs from not in clause?

995

How is SQL Azure different than SQL server?

225

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