| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is blocking and how would you troubleshoot it? | | 1 |
| how to rename the table | | 3 |
| After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback ) | iGate | 2 |
| When you first load SQL SERVER you will startup with what
all databases? | CompuSol | 3 |
| What is mean by "fill factor" ? and what is mean
by "Index "in sql? | Logica-CMG | 1 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| what is web server?
| Satyam | 3 |
| what are the new features of sql server 2005? | HP | 6 |
| How can your resolve deadlocks? | IBM | 3 |
| plz send every query in sql server2000 | Infosys | 1 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 5 |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| What are explicit and implicit transactions? | | 2 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 3 |
| Explain the architecture of SQL Server? | | 2 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| How do you persist objects, permissions in tempdb | | 1 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| |
| For more SQL Server Interview Questions Click Here |