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

how you can move data or databases between servers and databases in sql server? : Sql server administration

974

can a table be moved to different filegroup? : Sql server administration

984

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1081

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1257

What is the difference between a fill factor of 100 and 0?

985

A trigger can reference objects outside the current database? State true or false.

1015

How can you list all the table constraints in a database?

941

explain extended properties

997

What are the results of running this script?

937

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1010

How can you stop stored procedures from recompiling?

904

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

995

What is a livelock?

973

What are alternate keys?

985

What does it mean to normalize a database and why would you do it?

984

Un-Answered Questions { SQL Server }

What are the purposes and advantages stored procedure?

961

What is 1nf normalization form?

1041

How do I run sql server 2014?

1009

What are the recovery models for a database?

1108

What do you mean by collation recursive stored procedure?

1060

What are SSL and TSL protocols?

1000

Where are stored procedures in sql server?

1070

How to backup encryption key ?

185

How optimize sql query with multiple joins in sql server?

907

How would you use user_constraints table in DB?

1009

Explain about sql server login?

1092

How to return the top 5 rows from a select query in ms sql server?

1146

What is a subquery in a select query statement in ms sql server?

1136

What is 2nf example?

1001

How to test subquery results with the exists operator?

1108

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