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

958

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

968

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

1046

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

1249

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

976

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

1003

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

935

explain extended properties

985

What are the results of running this script?

919

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?

1004

How can you stop stored procedures from recompiling?

895

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

983

What is a livelock?

954

What are alternate keys?

976

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

976

Un-Answered Questions { SQL Server }

How to list all stored procedures in the current database using ms sql server?

1127

What are the difference between primary key and unique key? : sql server database administration

936

Can you tell me about the concept of ER diagrams?

1063

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

976

What is the difference between truncate and delete commands?

1062

Can group functions be used in the order by clause in ms sql server?

1012

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2066

What are translations and its use? : sql server analysis services, ssas

1036

What are tables in sql server?

1030

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1944

What is logon trigger?

1086

Can a cursor be updated? If yes, how you can protect which columns are updated?

1102

What is the data type of time?

961

What are the purpose of Normalisation?

1048

What is acid db?

881

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