| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| What is a Stored Procedure? | | 7 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| Which institute is best for SQL Server 2005 Training? | | 5 |
| Difference between Function and Stored Procedure? | C1-India | 4 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| Anyone please explain me the concept of Serialization? | | 3 |
| what are file groups? | Evalueserve | 3 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| How will u get 5 years back record? | | 4 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 2 |
| What is a function? Give some example? | | 2 |
| which one will take 1st priority in case of insert statement
and select statement??? | | 1 |
| How to tune a stored procedure? | | 5 |
| What is de-normalization and when do you do it? | | 3 |
| Questions regarding Raiseerror? | | 1 |
| can you any body tell me which service pack is installed in
the sql server? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |