| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the authentication modes in SQL Server? | | 2 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| what is cluster and nin-cluster index? | | 2 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 3 |
| How to write stored procedure to update the data in 10
tables | | 3 |
| About DTS usage ? | Cognizent | 2 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 1 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 7 |
| How do we rollback the table data in SQL Server | | 2 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| How do you fine the performance tunning? | Accenture | 2 |
| What is Covering Indexes?
Plz explain with example | | 1 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 2 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
