| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| what is web server?
| Satyam | 3 |
| How will u find the query which is running in some other
machine | IBM | 2 |
| what is the difference between group and having
give an example with query and sample output | | 2 |
| what is the query and condition to delete datas in sql
server. | | 2 |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| what are the new features of sql server 2005? | HP | 6 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| how insert selected column only ? | Robert-Half | 2 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| Explain Active/Active and Active/Passive cluster
configurations? | | 1 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| 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 |