| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how can i view structure of table in sql server? tell me
that query. | | 4 |
| Anyone please explain me the concept of Serialization? | | 3 |
| How to tune a stored procedure? | | 5 |
| how can i store resumes in database? | HCL | 2 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| What is an index? | Yardi-Software | 7 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 4 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| Define candidate key, alternate key, composite key. | | 9 |
| What is Trigger? | Misys | 2 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| How do you troubleshoot SQL Server if its running very slow? | | 2 |
| what is difference between primary key and Unique | | 8 |
| What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning | TCS | 2 |
| what is the difference between sql query and google query? | TCS | 6 |
| what is normalization?
what is denormalization?
| Satyam | 5 |
| How do you find the number of rows in a table? | | 5 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| what command is used to create a table by copying the
structure of another table? | | 5 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
