Some questions whcih were asked by interviewers :-

1) Why clustered index are only 1 and non clustered indexes are many?

Also, if for a table we have just non clustered indexes and no clustered index, will the performance be good or

bad ?

2) If you are backing up your databases in this way...

1 full backup daily and rest all transaction logs every half an hour daily.

and u want to restore and you notice 1 transaction log in between is damaged.

can you recover all of your data ?

3) What differences you note when u install 2005 and 2008 standard editions.

4) In log shipping, if you have a 1 tb db on primary and on secondary the drive is being getting full by logs.

What can you do( on secondary) other than increasing the disk drive space to accomodate the logs?

5) In merge replication, what will happen if there are many push updates from both publisher and subscriber at same times/ many transactions occuring at same time?

Regards,

Skybvi