| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| can you any body tell me the how to decrease the logfile | | 4 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 10 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| how to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| Why Do you want to work in this company? | HCL | 3 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| How to find out name of all employees who has salary less
than 200 Rs.? | | 7 |
| What's the difference between a primary key and a unique
key? | | 4 |
| Which virtual table does a trigger use? | | 3 |
| what purpose does OPENXML clause have in sql server stored
procedure? | | 1 |
| what is diffence between replicaion and logshipping? | | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| What are mdf,ndf,ldf files and how to see the data in those
files? | Accenture | 5 |
| employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come. | | 2 |
| what is differece between union and union all | | 4 |
| Explain the basic concepts of SQL server architecture? | | 2 |
| Can we rewrite subqueries into simple select statements or
with joins? Example? | ASD | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
