| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| what is physical sort data and logical sort data in index? | | 2 |
| What is normalization? | | 6 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| Plz tell about backup&recovery? | | 2 |
| what is normalization?
what is denormalization?
| Satyam | 5 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| what is difference between having and where clause ? | | 2 |
| Questions on identity? | Infosys | 1 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| Which databases are part of SQL server default installation?
Explain the usage of each? | Accenture | 2 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| What is transcation?Plz give One example? | | 2 |
| What command do we use to rename a db? | | 3 |
| What is the difference between temp table and table variable? | Microsoft | 4 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| What is an Index? | Yardi-Software | 3 |
| What is a Trace frag?Where can we use this? | | 1 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |