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

902

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

1015

what happens on checkpoint? : Sql server database administration

1038

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

952

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

907

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

1044

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

870

what is create database syntax? : Sql server database administration

1063

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

935

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

1029

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

956

what is dbcc? : Sql server database administration

984

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

935

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

980

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

1021

Un-Answered Questions { SQL Server }

how can you check the level of fragmentation on a table? : Sql server administration

933

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2039

Give me a SQL Query to find out the second largest company?

1134

What is a coalesce function?

1142

Define right outer join in sql server joins?

1002

Â Explain what is sql override for a source taLle in a mapping?

964

how many clustered indexes can be created on a table? : Sql server database administration

1087

Why do you need a sql server?

1050

What is query and its types?

882

Do you know what is openxml in sql server?

1029

How to provide default values to stored procedure parameters?

1019

why would you use sql agent? : Sql server database administration

1137

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

1046

What is the use of commit?

972

Does group by or order by come first?

913

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