| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| explain different types of jions with examples briefly? | Zensar | 2 |
| what is normalization?
what is denormalization?
| Satyam | 4 |
| What is blocking and how would you troubleshoot it? | | 1 |
| how to find nth highest salary | | 21 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 1 |
| how to select a field with firstletter as capital and
remaining are small letters | | 6 |
| What is MSDE? | | 1 |
| What is lock escalation? | | 1 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take? | | 1 |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| How many index keys possible for a table | | 6 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 2 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| 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 |
| What's the difference between DELETE TABLE and TRUNCATE
TABLE commands? | | 6 |
| Explain the new features of SQL server 2000? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map