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

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 8142

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 18890

Which system tables contain information on privileges granted and privileges obtained

1 7161

Which system table contains information on constraints on all the tables created?

2 7416

what command is used to create a table by copying the structure of another table?

7 15104

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 9849

What is the use of CASCADE CONSTRAINTS?

3 11424

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

Crown Solutions,

2072

What are the type of Indexes? which one is best, why?

6 9907

How to work on DTS?what is the main requirement?

Getit, ivan,

1 5856

I have student marks in a student table. I need second highest mark .Then what will the query for this?

NetCore, Patni, SAP Labs, Temenos, Wipro,

37 69972

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 184916

About types of indexes in SQL server ?

Cognizant,

2 7935

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 77554

About DTS usage ?

Cognizant, Wipro,

2 8222

Un-Answered Questions { SQL Server }

Why is normalisation important?

989

What are the different index configurations a table can have?

1015

What methods do you follow to protect from sql injection attack?

1078

What is difference between equi join and inner join?

1043

Explain unique key in sql server?

1053

What are cascading parameters in ssrs reports?

236

How do I view a stored procedure in sql server query?

986

Explain the disadvantages/limitation of the cursor?

1014

Explain syntax for viewing trigger?

972

What is a raid and what are different types of raid configurations?

1327

What is faster join or union?

1325

What is implicit cursors?

1139

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1060

Does partitioning improve performance?

1023

What is the difference between dropping a database and taking a database offline?

1226

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