| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.
Again if we select multiple items in second listbox then the
related to those selected items should display .
In this scenario how will you design database,tables? | HP | 1 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| What are the different types of replication? How are they used? | | 3 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| What is indexed views?
plz explain with example? | | 1 |
| What is blocking and how would you troubleshoot it? | HCL | 2 |
| Plz tell about backup&recovery? | | 2 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 2 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| how insert selected column only ? | Robert-Half | 2 |
| How do you fine the performance tunning? | Accenture | 2 |
| how to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| How do you persist objects, permissions in tempdb | | 1 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
