| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| write query for fourth maximum salary from employee table | Mind-Tree | 5 |
| Alternative way to DetDate() function? | | 4 |
| How to create logins using windows Authentication mode? | | 2 |
| What is database normalization? | Digicel | 5 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 10 |
| Difference between Function and Procedure-in general? | | 3 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| 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 is lock escalation? | | 1 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| write down the code for "how we delete a table without
using of Drop command " ? | Sonata | 2 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| what is the difference between Delete and Truncate | Geo-Research-Centre | 3 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| Differnce between sel server 2000 and 2005 | | 3 |
| Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
| | 2 |
| What is the difference between a Application Server and a
Database | Oracle | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
