| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| About DTS usage ? | Cognizent | 2 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 6 |
| difference between sql server2000 and sql server2005
| KPMG | 1 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| 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 are the type of joins? When do we use Outer and Self joins? | | 3 |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| What is a transaction and what are ACID properties? | IBM | 4 |
| Is it possible to create a stored procedure that runs a
query and outputs the results to a text file and allows me
to add extra delimeters and static field info. If so How? | | 1 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| What is row by row processing ? | | 1 |
| 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 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 9 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| what is the diffrence between Snap Shot and Transaction
Replication | CSC | 1 |
| What is blocking and how would you troubleshoot it? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
