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 8144

What is a view?

6 9210

What is an Index?

Yardi Software,

3 9592

What are the types of indexes available with SQL Server?

Standard Bank,

2 7926

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

Infogain,

9 37904

What are cursors?

8 10929

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 18687

Which TCP/IP port does SQL Server run on?

2 9870

From where can you change the default port?

3 6863

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

15 24557

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

Shriram,

2 10142

What is the use of DBCC commands?

NA,

4 9153

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,

2469

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 4622

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

World Tech, Yardi Software,

11 29262

Un-Answered Questions { SQL Server }

Is sql different from sql server?

1011

What are the mathematical functions supported by sql server 2005?

1007

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1814

What are the differences between local and global temporary tables?

1022

Explain what is the purpose of sql profiler in sql server?

1017

What is the datatype of rowid?

885

what kind of lan types do you know? : Sql server database administration

934

How to run sql server 2005 books online on your local system?

926

What is conditional split?

1008

Explain the database you used in your final year project?

982

Explain different types of collation sensitivity?

938

What are the acid properties?

955

What is equi join with example?

1027

what data regions are and what are the different data regions?

132

How to delete a login name in ms sql server?

1012

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