| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| What is SQL Profiler what is the use of it? | 247Customer | 2 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| can you any body tell me the difference between candidate
key and primary key | | 4 |
| What is an index? | Yardi-Software | 7 |
| What is a trigger? | | 3 |
| What is the difference between DTS and SSIS? | Allianz | 3 |
| How can your resolve deadlocks? | IBM | 3 |
| How to link up the text file to a Database table? | Allianz | 1 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| what is curser. | | 9 |
| event classes in sql server | Accenture | 1 |
| write the query for taking database restore in sql? | | 2 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| |
| For more SQL Server Interview Questions Click Here |