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

1161

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

1014

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

1180

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

1108

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

1089

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

1086

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

1109

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

969

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

911

what are defaults? : Sql server database administration

1162

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

1045

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

1116

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

1011

what is sql server? : Sql server database administration

1043

what is denormalization? : Sql server database administration

973

Un-Answered Questions { SQL Server }

What are alternate keys?

1030

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

1018

Can we do dml on views?

1015

How to convert binary strings into integers in ms sql server?

1080

What are the recovery models for a database?

1146

What is best institute to Learn DotNET And SQL in chennai?

2219

How to fetch the next row from a cursor with a "fetch" statement?

1110

Can we use where and having clause together?

1097

What is the difference between Stored Procedures and triggers?

1133

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1107

How to grant a permission in ms sql server using "grant execute" statements?

1135

Is the log file is a part of file group?

1095

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1069

How to use go command in "sqlcmd"?

1264

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1076

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