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 8020

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

TCS,

3 18711

Which system tables contain information on privileges granted and privileges obtained

1 7086

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

2 7299

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

7 14826

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

2 9729

What is the use of CASCADE CONSTRAINTS?

3 11237

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,

2033

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

6 9661

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

Getit, ivan,

1 5760

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 68447

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 181575

About types of indexes in SQL server ?

Cognizant,

2 7791

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 76860

About DTS usage ?

Cognizant, Wipro,

2 8082

Un-Answered Questions { SQL Server }

In which tcp/ip port does sql server run? Can it be changed?

983

Explain about sql server login?

1075

Explain features of analysis services?

990

What are number line correlation administrators will use while working with a subquery?

1167

What do you understand by coalesce in sql server?

1063

List the data types available in mssql?

1024

Explain view in sql server?

1051

What are the types of ssrs?

145

What are the new features are introduced in sql server 2012 reporting services?

149

What are different types of database indexes?

1089

What are different types of join?

1304

Explain a join?

1058

What is the use of stored procedure?

933

List out the difference between union and union all in sql server?

983

Write SQL queries on Self Join and Inner Join.

1146

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