| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 3 |
| What is a Join in SQL Server? | | 1 |
| Explain some DBCC commands? | | 3 |
| How to Get the last identity value used | | 3 |
| Display a roll having miminum marks in two subjects? | Patni | 4 |
| What is the difference between OLEDB and ODBC | CFCI | 2 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| 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 can you get @@error and @@rowcount at the same time? | | 4 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 4 |
| What's the difference between DELETE TABLE and TRUNCATE
TABLE commands? | | 6 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| How to count the number of duplicate items in a table? | | 1 |
| What are primary keys and foreign keys? | | 3 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| How To delete duplicate record from a particular table? | eXensys | 8 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| What are the four main query statements? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
