| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the two types of concurrency? | | 2 |
| what is meant by deafult in sql server?
| | 2 |
| The Difference between 'Count' and 'Count(*)' | | 8 |
| What is a job? | | 3 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 4 |
| What is data integrity? Explain constraints? | | 1 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 4 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
| HCL | 2 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| What is an extended Stored Procedure? | | 1 |
| Which virtual table does a trigger use? | TCS | 5 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| Difference between Triggers and Stored Procedure | Protech | 7 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| What's the difference between a primary key and a unique key? | Wipro | 7 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| How do you fine the performance tunning? | Accenture | 2 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| to explain sql server 2000 architecture & authentication | | 1 |
| |
| For more SQL Server Interview Questions Click Here |