| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| how can do you the system monitoring? | | 1 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 6 |
| Difference between Cluster and Non-cluster index? | Oracle | 6 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 9 |
| What is a view? is View updatable? | IBM | 10 |
| Wht is SQL Injection Attack ? | | 1 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 12 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 4 |
| What is ACID Property of Transaction? | | 3 |
| What are functions | | 3 |
| Difference between Triggers and Stored Procedure | Protech | 7 |
| What is a cursor in SQL Server 2000 and their types? | | 2 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| How to link up the text file to a Database table? | Allianz | 1 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same? | Microsoft | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map