| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal. | | 7 |
| what is diffence between replicaion and logshipping? | | 1 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 5 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 7 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| What is a function? Give some example? | | 2 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| How many index keys possible for a table | | 6 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| What is the use of DBCC commands? | | 1 |
| What is Trigger? | Misys | 2 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable) | | 1 |
| From where can you change the default port? | | 3 |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| What is Report Server,Report Manager and Report Builder in
SSRS 2005? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
