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 7924

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

TCS,

3 18585

Which system tables contain information on privileges granted and privileges obtained

1 7038

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

2 7239

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

7 14652

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

2 9636

What is the use of CASCADE CONSTRAINTS?

3 11102

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,

2004

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

6 9480

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

Getit, ivan,

1 5693

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 67572

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 179293

About types of indexes in SQL server ?

Cognizant,

2 7705

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 76353

About DTS usage ?

Cognizant, Wipro,

2 7990

Un-Answered Questions { SQL Server }

How to convert a numeric expression from one data type to another?

951

What is the function of inner join?

1018

What xml support does the sql server extend?

971

between cast and convert which function would you prefer and why?

924

Define left outer join?

934

What are the types of indexing?

1042

Why use sub query in sql server and list out types of sub queries?

949

Can you tell me some of the common replication dmv's and their use? : sql server replication

879

How you can change the database name in SQL SERVER?

1150

What is field with example?

877

Define clusters?

1008

What are partitioned views and distributed partitioned views?

988

Explain Reporting Life Cycle?

116

What are the three different part of rdl file explain them?

257

Explain what are various ways to enhance the ssrs report?

1000

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