Explain transaction server isolation?
What are the benefits of using stored procedures over sql statements?
Differentiate between SQL and ORACLE joins and write their syntax.
What is the maximum size per database for sql server express?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain what are commit and rollback in sql?
What is partitioned view?
What is the difference between Normalization and De-normalization?
Can you leave a union at any time?
What is data source in connection string?
Explain system views?
Explain transaction isolation levels in sql server?
How you provide security to cube? : sql server analysis services, ssas