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 is a trigger?

4 8308

What is a view?

6 9414

What is an Index?

Yardi Software,

3 9696

What are the types of indexes available with SQL Server?

Standard Bank,

2 8045

What is the basic difference between clustered and a non-clustered index?

Infogain,

9 38199

What are cursors?

8 11206

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 18890

Which TCP/IP port does SQL Server run on?

2 9982

From where can you change the default port?

3 6988

Can you tell me the difference between DELETE & TRUNCATE commands?

15 25169

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

Shriram,

2 10269

What is the use of DBCC commands?

NA,

4 9313

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

iSoft,

2523

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 4725

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

World Tech, Yardi Software,

11 29657

Un-Answered Questions { SQL Server }

Where can you find the error log information? : sql server database administration

1025

What to perform pattern match with the like operator?

883

What is user-defined function?

975

Explain the use of containers in ssis?

965

How to get a list all databases on the sql server?

1101

What are truncate options available in sql server? : sql server database administration

1030

What is default constraint?

995

What are unicode character string data types in ms sql server?

1254

Can select statements be used on views in ms sql server?

1065

User wants only to display only pdf as export option in report manager. How to achieve this?

262

How to find the service pack installed? : sql server database administration

1023

Explain the stored procedure?

1053

What is RMS migrations?

2134

What are subquery and its properties?

1049

what is the sql equivaent of the dataset relation object ?

2027

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