Define constraints and give an example of their use?
Can foreign key be duplicate?
What are the properties of sub-query?
What is the purpose of optimization?
Explain what are magic tables in sql server?
Why do we use non clustered index?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is an identity column in insert statements?
What is attribute hierarchy? : sql server analysis services, ssas
Write down the syntax and an example for create, rename and delete index?
What are the authentication modes in SQL Server?
What is difference between rownum and rowid?
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?