| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a deadlock and what is a live lock? How will you go
about resolving deadlocks? | Microsoft | 1 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 10 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| what is the difference between Delete and Truncate | Geo-Research-Centre | 3 |
| How can your resolve deadlocks? | IBM | 3 |
| What is the difference between truncate and delete statement? | CTS | 4 |
| what are file groups? | Evalueserve | 3 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| What is the role that is required for killing a process
What is the role that is required for creating a linked
server
| IBM | 1 |
| When do you use SQL Profiler? | | 2 |
| 1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;" | | 6 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| event classes in sql server | Accenture | 1 |
| Can we create clustered index on non primary key column | CTS | 14 |
| What do you mean by COLLATION? | | 4 |
| From where can you change the default port? | | 3 |
| We create an index to fast the search. How it fast the
query? Do we write any special keyword with query? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
