| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| how do u do Performance tunning ?
| Satyam | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| which database is best to use in oracle and sql server?
explain reasons? | TCS | 5 |
| What is excution Plan in sql server | TCS | 1 |
| What is MSDE? | | 2 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| what is physical sort data and logical sort data in index? | | 2 |
| Explain Trigger with an example?
| | 1 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| How to link up the text file to a Database table? | Allianz | 1 |
| Which system table contains information on constraints on
all the tables created? | | 2 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| Explain sp_configure commands, set commands? | | 3 |
| how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)? | Marlabs | 8 |
| |
| For more SQL Server Interview Questions Click Here |