| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| Which institute is best for SQL Server 2005 Training? | | 5 |
| What is the difference between constraints and triggers? | Wipro | 6 |
| what are the new features of sql server 2005? | HP | 5 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| Explain DBMS, RDBMS? | | 4 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| Can we create clustered index on non primary key column | CTS | 14 |
| How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query? | | 2 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 5 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| can you any body tell me the difference between candidate
key and primary key | | 4 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| What is the role that is required for killing a process
What is the role that is required for creating a linked
server
| IBM | 1 |
| How do you troubleshoot SQL Server if its running very slow? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |