| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to count the number of duplicate items in a table? | | 1 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)? | | 1 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| how to implement locking in sql server | Satyam | 1 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| how to rename the table | | 3 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| What is a deadlock and what is a live lock? How will you go
about resolving deadlocks? | Microsoft | 1 |
| What's the maximum size of a row? | | 4 |
| What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages. | 247Customer | 3 |
| What is the difference Between Sql-server 2000 & 2005 | Value-Labs | 2 |
| how do we find every fifth record in a table | | 11 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 23 |
| is there more the two primary key in a single table? | Systematix | 22 |
| How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all) | McAfee | 4 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
