SQL Server Interview Questions - Capgemini

1. How to automatically create a log when an exception is being received into SQL Server?
2. Explain what is meant by replication of database?
3. What is the optimization being performed in oracle and SQL Server?
4. Write a SQL query to make a column as unique?
5. How many tables can be joined in SQL Server?
6. How many columns can exist together per table?
7. What is SQL Profiler?