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 4776

What is a view?

6 5842

What is an Index?

Yardi Software,

3 6568

What are the types of indexes available with SQL Server?

Standard Bank,

2 5511

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

Infogain,

9 32721

What are cursors?

8 6303

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 15533

Which TCP/IP port does SQL Server run on?

2 8127

From where can you change the default port?

3 4913

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

15 17076

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

Shriram,

2 7797

What is the use of DBCC commands?

NA,

4 6361

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,

1615

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 2966

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

World Tech, Yardi Software,

11 22798

Un-Answered Questions { SQL Server }

What is SubQuery in SQL Server 2008

150

What is the difference between a stored procedure and a user defined function?

101

What is ms sql server reporting services?

112

Explain about thread and memory management process of SQL?

155

Is truncate a dml command?

104

is there a column to which a default can't be bound? : Sql server database administration

112

Can group functions be used in the order by clause in ms sql server?

152

Are resultset updatable?

What is data source in connection string?

how can a database be repaired? : Sql server administration

129

How many null values we can have in a unique key field in sql server?

153

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

125

Can we use pragma autonomous_transaction in trigger?

116

Difference between drill down and drill through report.

140

How to fetch the next row from a cursor with a "fetch" statement?

142

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