Database Interview Questions - Aditi

1. What does new grouping sets enables you to do?
2. Why merge statement is used inside the database?
3. Write a SQL command to insert and update only a particular field?
4. What is the advantage of varchar2 over char?