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?

908

Can foreign key be deleted?

887

Can a table have 2 primary keys?

949

What are the components of dbms?

919

Can an entity have two primary keys?

942

How is foreign key related to primary key?

936

Can foreign key be duplicate?

1016

What are the five major components of a dbms?

901

Can two tables have the same primary key?

1157

What are the properties of primary key?

934

What do you mean by normalisation?

987

What are the 3 types of schema?

1065

Can we join two tables without primary key?

996

What are the types of normalization?

984

What are the elements of dbms?

937

Un-Answered Questions { SQL Server }

when you create a database how is it stored? : Sql server database administration

970

How to create a local temporary stored procedure?

967

What is rs.exe utility?

154

Tell me what is the stuff and how does it differ from the replace function?

950

Explain different types of Normalization.

1764

What is the fillfactor concept in indexes?

952

How can I check that whether automatic statistic update is enabled or not?

1011

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1052

What is function of ROLLUP ?

1055

What are drillthrough reports?

147

What is the difference between NOROW and LOCKROW?

2794

Explain in details security in SQL azure?

121

How to create a large table with random data for index testing in ms sql server?

999

How can sql injection be stopped? : sql server security

981

How can a user-defined datatype be created?

951

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