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 are different types of backups available in sql server? : Sql server database administration

935

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1068

what happens on checkpoint? : Sql server database administration

1101

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

984

explain the storage models of olap? : Sql server database administration

958

how to create a scrollable cursor with the scroll option? : Sql server database administration

1091

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

908

what is create database syntax? : Sql server database administration

1104

what type of index will get created after executing the above statement? : Sql server database administration

971

what authentication modes does sql server support? : Sql server database administration

1106

how many layers of tcp/ip protocol combined of? : Sql server database administration

997

what is dbcc? : Sql server database administration

1031

how to define testing of network layers? : Sql server database administration

972

is there a column to which a default can't be bound? : Sql server database administration

1015

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1054

Un-Answered Questions { SQL Server }

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

121

What is raid, and how it can influence database performance?

1054

Can you explain what is sql server english query?

994

What is parameterized reports in ssrs ?

149

Why variables called the most powerful component of ssis?

1079

Tell me what is the significance of null value and why should we avoid permitting null values?

984

What are the tool windows in sql server management studio? : sql server management studio

1075

What happens if you add a new index to large table?

941

Does server sql treat char as a variable-length or fixed-length column?

1032

What is change data capture (cdc) in sql server 2008?

1024

How will you decide the active and passive nodes?

1128

What is transaction server consistency?

1046

What is merge statement?

1080

Define master database?

1066

Why olap is used?

969

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