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 8462

What is a view?

6 9599

What is an Index?

Yardi Software,

3 9850

What are the types of indexes available with SQL Server?

Standard Bank,

2 8157

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

Infogain,

9 38508

What are cursors?

8 11527

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 19084

Which TCP/IP port does SQL Server run on?

2 10071

From where can you change the default port?

3 7115

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

15 25636

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

Shriram,

2 10389

What is the use of DBCC commands?

NA,

4 9482

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,

2587

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 4830

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

World Tech, Yardi Software,

11 29992

Un-Answered Questions { SQL Server }

Can we install sql server 2016 on windows 7?

1201

How to download and install microsoft sql server management studio express?

1099

What is a cache in ssrs?

140

How to maintain a fill factor in existing indexes?

1060

Mention the differences between substr and charindex in sql server.

1120

What are subqueries in sql server?

1197

Explain transaction isolation levels in sql server?

1190

Can you move the resources after pausing the node? : sql server database administration

1171

Can foreign key be deleted?

979

What are 3 ways to get a count of the number of records in a table?

1127

How do I clean up sql server transaction log?

1129

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1176

Explain what is scheduled job and how to create it?

1026

What is the purpose of the tempdb database?

1050

Why de-normalization required?

1055

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