| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| logshipping is Any difference 2000 and 2005? | | 1 |
| How will u find the query which is running in some other
machine | IBM | 2 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| what is maximum size of temp db? | iSoft | 4 |
| how to generate XML out of QUERY? | McAfee | 1 |
| how to find nth highest salary | NexGen | 30 |
| What is a NOLOCK? | | 3 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| What is a Join in SQL Server? | | 2 |
| what is web server?
| Satyam | 3 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 2 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| what purpose does OPENXML clause have in sql server stored
procedure? | | 1 |
| what is diffence between replicaion and logshipping? | | 1 |
| Explain some DBCC commands? | | 4 |
| What is normalization? | | 6 |
| What are the two types of concurrency? | | 2 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| |
| For more SQL Server Interview Questions Click Here |