| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between having and where clause? | | 3 |
| What is a trigger? | | 3 |
| What is blocking and how would you troubleshoot it? | | 1 |
| syntax for deleting the database in T SQL | | 3 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| What's the difference between a primary key and a unique
key? | | 3 |
| What is Query Execution Plan? How does it help optimize or
tune a database driven application? | Accenture | 1 |
| What is the use of DBCC commands? | | 1 |
| What is the datatype returned by count(*) | Asian-CERC | 16 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| What does the INSTEAD OF trigger do? | | 2 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 2 |
| What is BCP? When do we use it? | | 1 |
| What is a cursor in SQL Server 2000 and their types? | | 2 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| What are the type of Indexes? which one is best, why? | | 5 |
| Can you explain the role of each service? | | 1 |
| Write an SQL query if u want to select the data from one
block which intern reflects in another block ?
thanx,do reply | Covansys | 1 |
| |
| For more SQL Server Interview Questions Click Here |