| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| where do you use Isolations?give me some exmpale? | | 1 |
| How many index keys possible for a table | | 6 |
| What are the types of model in sql server and explain | TCS | 1 |
| Define candidate key, alternate key, composite key. | | 9 |
| Wht is Stuff in sql ser | | 1 |
| What's the maximum size of a row? | | 4 |
| internal language used in sql server 2000? | | 1 |
| can foreign key take role of primary key?
| TCS | 4 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| What is database normalization? | Digicel | 5 |
| there is a table having two columns no and name
and the data is
1 A
2 B
3 C
write a query that will result a horizontal output
A,B,C
| vsworx | 7 |
| What are the authentication modes in SQL Server? | | 2 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 3 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 9 |
| How to tune a stored procedure? | | 5 |
| What is Report Server,Report Manager and Report Builder in
SSRS 2005? | | 1 |
| what is curser. | | 8 |
| What is ACID Property of Transaction? | | 4 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |