| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| what is replication?
where do u use Go Keyword?
| Satyam | 1 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| Advantages and Disadvantages of Cursor? | Zenith | 10 |
| Can you explain the role of each service? | | 1 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| What is an Index? | Yardi-Software | 3 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| What is ACID Property of Transaction? | | 4 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| How to find the last update record in SQL Server? | | 3 |
| What is de-normalization and when do you do it? | | 3 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| i want table name basis on column name. | | 5 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 7 |
| 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 |
| Wht is Stuff in sql ser | | 1 |
| |
| For more SQL Server Interview Questions Click Here |