| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 4 |
| Can you tell me the difference between DELETE & TRUNCATE
commands? | | 11 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| how insert selected column only ? | Robert-Half | 2 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 7 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| What is a trigger? | | 3 |
| What is a deadlock and what is a live lock? How will you go
about resolving deadlocks? | Microsoft | 1 |
| How do you troubleshoot SQL Server if its running very slow? | | 2 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 2 |
| What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages. | 247Customer | 3 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 3 |
| what is hash table | Teledata | 2 |
| i have table students with fields classname,studname
select * from students
classname studname
1 xxxxx
1 yyyy
1 zzzz
2 qqqq
2 tttt
3 dsds
3 www
i want the output should be
No of students in class 1 : 3
No of students in class 2 : 2
No of students in class 3 : 2
| HCL | 2 |
| What is transcation?Plz give One example? | | 2 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
