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 8045

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

TCS,

3 18738

Which system tables contain information on privileges granted and privileges obtained

1 7096

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

2 7307

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

7 14879

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

2 9741

What is the use of CASCADE CONSTRAINTS?

3 11261

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,

2036

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

6 9689

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

Getit, ivan,

1 5776

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 68691

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 181857

About types of indexes in SQL server ?

Cognizant,

2 7812

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 76934

About DTS usage ?

Cognizant, Wipro,

2 8099

Un-Answered Questions { SQL Server }

how can a database be repaired? : Sql server administration

971

What are the types of normalization?

1031

What is a periodical index?

927

What does null mean?

984

How will you go about resolving deadlocks?

970

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1061

What is b tree index?

915

What is a unique key constraint?

1028

What is sql stored procedure?

1093

Why and when do stored procedure recompile?

979

Define inner join? Explain with an example?

996

Find columns used in stored procedure?

991

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1187

What is 1nf 2nf?

1009

What is the server name for sql management studio?

1022

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