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

what is normalization? : Sql server database administration

1039

what is a traditional network library for sql servers? : Sql server database administration

904

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1086

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

979

what is a transaction and what are acid properties? : Sql server database administration

975

what's the information that can be stored inside a bit column? : Sql server database administration

983

what is an extended stored procedure? : Sql server database administration

1009

what is the different types of backups available in sql server? : Sql server database administration

894

when would you go for denormalization? : Sql server database administration

828

what are defaults? : Sql server database administration

1032

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

937

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1012

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

934

what is sql server? : Sql server database administration

947

what is denormalization? : Sql server database administration

892

Un-Answered Questions { SQL Server }

Can binary strings be used in arithmetical operations?

905

What is the difference between Normalization and De-normalization?

1042

What are the restrictions that views have to follow?

923

Is sql server difficult to learn?

875

Which tcp/ip port does the sql server run on? How can it be changed?

1007

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

908

How to create percentile function?

143

What is 2nf example?

960

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

What is the security principal at the database level that represents your session?

909

What is a transact-sql statement batch in ms sql server?

965

Explain the stored procedure?

1001

What do you understand by hotfixes and patches in sql server?

928

Tell about MOM Tool(Microsoft Operator Manager)?

1872

How to loop through the result set with @@fetch_status?

1276

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