| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What does the INSTEAD OF trigger do? | | 2 |
| what is replication?
where do u use Go Keyword?
| Satyam | 1 |
| How m-m relationships are implemented? | | 1 |
| What is a cursor in SQL Server 2000 and their types? | | 2 |
| What are constraints? Explain different types of
constraints? | | 4 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| How to Get the last identity value used | | 3 |
| What is data integrity? Explain constraints? | | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
| HCL | 1 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 4 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| Wht is SQL Injection Attack ? | | 1 |
| Alternative way to DetDate() function? | | 2 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 1 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 1 |
| can any one please send sql quries most used in applications. | | 1 |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| How many index keys possible for a table | | 6 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map