| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the system function to get the current user's user
id? | TCS | 3 |
| How will u find the query which is running in some other
machine | IBM | 2 |
| is there more the two primary key in a single table? | Systematix | 22 |
| What is a stored procedure? | | 3 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths" | | 1 |
| Define candidate key, alternate key, composite key. | | 9 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| What is the purpose of using COLLATE in a query? | | 1 |
| Which virtual table does a trigger use? | TCS | 6 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| What is transaction ? Give me one example. | Melstar | 7 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| What are constraints? Explain different types of
constraints? | | 6 |
| when we use function instead of procedure? plz tell me the
situation with ex? | | 1 |
| What is the difference between DTS and SSIS? | Allianz | 3 |
| what is difference between nchar and char in Sql server ?
| | 2 |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
