| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the types of indexes available with SQL Server? | | 2 |
| What is the difference between a Application Server and a
Database | Oracle | 2 |
| Which databases are part of SQL server default installation?
Explain the usage of each? | Accenture | 2 |
| Can you give an example of Stored Procedure? | | 2 |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 5 |
| How do you know which index a table is using? | | 4 |
| What is SQL Profiler what is the use of it? | 247Customer | 2 |
| Can Having clause be used without Group by clause? | CTS | 4 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| from the table display the 2nd highest salary?
and also the least 2nd salay?
| | 6 |
| How to create logins using windows Authentication mode? | | 2 |
| What are explicit and implicit transactions? | | 2 |
| Which institute is best for SQL Server 2005 Training? | | 5 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| Why we need a group by clause? | | 3 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| What is a function? Give some example? | | 2 |
| Difference between server.transfer and server.execute method? | | 1 |
| What are the advantages of using views. Why do we need
views when we have SPs? | 247Customer | 3 |
| |
| For more SQL Server Interview Questions Click Here |