| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the system function to get the current user's user
id? | TCS | 2 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 1 |
| What is database normalization? | Digicel | 5 |
| where do you use Isolations?give me some exmpale? | | 1 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| HOW TO RENAME A COLUMN NAME | | 1 |
| how can do you the system monitoring? | | 1 |
| What are constraints? Explain different types of
constraints? | | 5 |
| what is advantages in sql 2005 over sql 2000? | | 1 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| Which virtual table does a trigger use? | TCS | 5 |
| how to get the automatic backup of the database in the sql
server | | 3 |
| i want table name basis on column name. | | 2 |
| How can your resolve deadlocks? | IBM | 3 |
| How many index keys possible for a table | | 6 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 1 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 5 |
| Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.? | | 2 |
| Explain the new features of SQL server 2000? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
