| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| what are file groups? | Evalueserve | 3 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 2 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
| HCL | 2 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| what is meant by deafult in sql server?
| | 2 |
| what is the query and condition to delete datas in sql
server. | | 2 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| Explain some DBCC commands? | | 4 |
| select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal. | | 7 |
| how to generate XML out of QUERY? | McAfee | 1 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| How will u get 5 years back record? | | 4 |
| Explain Active/Active and Active/Passive cluster
configurations? | | 1 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 4 |
| What is a Linked Server? | | 1 |
| how to delete duplicate rows from table | CSC | 9 |
| What is lock escalation? | | 1 |
| What is Schema? and why we use schemas? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |