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?

1004

Can foreign key be deleted?

979

Can a table have 2 primary keys?

1033

What are the components of dbms?

999

Can an entity have two primary keys?

1033

How is foreign key related to primary key?

1015

Can foreign key be duplicate?

1121

What are the five major components of a dbms?

965

Can two tables have the same primary key?

1272

What are the properties of primary key?

1020

What do you mean by normalisation?

1115

What are the 3 types of schema?

1181

Can we join two tables without primary key?

1097

What are the types of normalization?

1079

What are the elements of dbms?

1015

Un-Answered Questions { SQL Server }

what is a transaction? : Sql server database administration

1054

What are binary string data types in ms sql server?

1395

What is ddl and dml commands?

961

What are the different types of upgrades that can be performed in sql server?

1217

What does it mean if @@cursor_row returns a negative number?

1041

What is difference between clustered index and non clustered index?

1126

Is foreign key a primary key?

1180

How do you create an execution plan?

1011

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1875

What is an index in sql?

1072

Explain the collation?

1149

In what sequence sql statement is processed?

1057

what is database replication? : Sql server database administration

1132

What are “lost updates”?

1045

How to delete database objects with "drop" statements in ms sql server?

1152

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