| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Please give me queries for the following
1. To get the count of duplicate records.
2. A query to delete the duplicate records. | 247Customer | 3 |
| Which virtual table does a trigger use? | TCS | 6 |
| What is a Lock and let me know Different types of locks? | | 1 |
| From where can you change the default port? | | 3 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| What are Magic Table? | Evalueserve | 15 |
| What is Transaction? | | 2 |
| What is SQL server agent? | SAP-Labs | 2 |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| write the query for find the top 2 highest salary in sql
server | TCS | 23 |
| 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 database replicaion? What are the different types
of replication you can set up in SQL Server? | | 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 difference between Triggers and store procedure? | | 2 |
| What is a function? Give some example? | | 2 |
| Which institute is best for SQL Server 2005 Training? | | 5 |
| How m-m relationships are implemented? | | 1 |
| What is an index? | Yardi-Software | 7 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 6 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| |
| For more SQL Server Interview Questions Click Here |