| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 15 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| what is meant by deafult in sql server?
| | 2 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 23 |
| What is a NOLOCK? | | 3 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| Advantages and Disadvantages of Cursor? | Zenith | 10 |
| How to find out name of all employees who has salary less
than 200 Rs.? | | 7 |
| what is the signification difference of this bit data type
between sql 6.5 and later version sql server? | | 1 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| Can we have more than one NULL in a column having unique
constraint? | 247Customer | 7 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| what are the new features of sql server 2005? | HP | 6 |
| write down the code for "how we delete a table without
using of Drop command " ? | Sonata | 2 |
| What's the maximum size of a row? | | 4 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
