| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| Differnce between sel server 2000 and 2005 | | 3 |
| Difference between sql server 2000 and sql server 2005?
| Satyam | 4 |
| write the query for taking database backup in sql | Logica-CMG | 6 |
| how to rename the table | | 3 |
| what is the Enterprise manager(2000) and management studio
(2005)? | | 2 |
| Questions on identity? | Infosys | 1 |
| how to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| What is an Index? | Yardi-Software | 3 |
| What is the order in which the SQL query is executed? list
them in order. | CTS | 1 |
| what is diffence between replicaion and logshipping? | | 1 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| What is BCP? When do we use it? | | 1 |
| how many type of subquery? | | 2 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| Define candidate key, alternate key, composite key. | | 9 |
| Is trigger fired implicitely? | | 2 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| |
| For more SQL Server Interview Questions Click Here |