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?

947

Can foreign key be deleted?

924

Can a table have 2 primary keys?

983

What are the components of dbms?

954

Can an entity have two primary keys?

981

How is foreign key related to primary key?

971

Can foreign key be duplicate?

1061

What are the five major components of a dbms?

929

Can two tables have the same primary key?

1208

What are the properties of primary key?

974

What do you mean by normalisation?

1043

What are the 3 types of schema?

1110

Can we join two tables without primary key?

1054

What are the types of normalization?

1031

What are the elements of dbms?

967

Un-Answered Questions { SQL Server }

How to view the error log for any specific instance? : sql server database administration

1040

Can you name some of the dml commands in sql?

1032

How do we know if any query is retrieving a large amount of data or very little data?

975

How do I shrink an ldf file?

980

What is the need for indexing?

951

How many non clustered indexes there can be on table ?

920

What is temporary stored procedure?

949

When would you prefer to have a minimum number of indexes?

906

how can you attach more than 20 ldf files in sql server

2001

How would you use user_constraints table in DB?

1008

Write a SQL query to make a column as unique?

1040

Do you know nested transaction?

958

What are constraints in microsoft sql server?

1132

What is normalization process?

1179

What is normalization and what are the advantages of it?

985

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