Part 1: Question and Answer
Question 1: Difference between Indexed Table and Indexed View.. Indexes on table are generally always used. You will have at least one unique index and one of the indexes will be clustered. Indexes on views are generally only applied as an optimization technique. Indexes on the view can improve performance using the views.
Question 2: Clustered VS non-clustered index

Question 3: Explain HIP table
A: Heap table is a table that does not have any Clustered Index.
Question 4: Maximum number of columns a table can have for SQL Server 2000, 2005, 2008 and 2012
A: 1024
Question 5: Difference between Delete and Truncate Delete and Truncate they both delete data. Difference is Delete keeps a record in the log file but truncate does not keep any record in the log file. So if you do a truncate operation you won't have any option to recover at a later time.
Question 6: What is rollback?
A: Rolls back an explicit or implicit transaction to the beginning of the transaction, or to a savepoint inside the transaction. You can use ROLLBACK TRANSACTION to erase all data modifications made from the start of the transaction or to a savepoint. It also frees resources held by the transaction. ROLLBACK { TRAN | TRANSACTION } [ transaction_name | @tran_name_variable | savepoint_name | @savepoint_variable ] [ ; ]

Question 7: Difference between Primary Key and Unique Key Primary key does not allow NULL values for any column. But unique key allows one and only one NULL value in a column for the table. A table can have only one Primary key but can have more than unique keys. By default a primary key creates a clustered index on the column but unique key creates a non-clustered index.

Question 8: What is star schema and Snowflake schema? Which schema do you prefer and why?
A: star