I am posting some interview questions I came across in one of my interviews.
a) This is a scenario. I have a table Table1 with 10 lac rows.I want to delete 9 lac records from the table. What are the steps you follow.?
b) What is the difference between UNION ALL and full outer join.
I have a table Table 1 with Col1 has 5 records
I have a table Table 2 with Col1 has 5 records
What will be the difference in output for UNION ALL and full outer join?