| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
| | 2 |
| can you any body tell me the difference between candidate
key and primary key | | 4 |
| How to count the number of duplicate items in a table? | | 1 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| What are the types of indexes available with SQL Server? | | 2 |
| Questions regarding Raiseerror? | | 1 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| What are explicit and implicit transactions? | | 2 |
| What is a Lock and let me know Different types of locks? | | 1 |
| What is Covering Indexes?
Plz explain with example | | 2 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
Regards,
Rupesh
| | 3 |
| What is Transaction? | | 2 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| |
| For more SQL Server Interview Questions Click Here |