What is UNION,UNION ALL? –

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is UNION,UNION ALL? –

UNION : eliminates duplicates
UNION ALL: retains duplicates
Both these are used to combine the results of different SELECT statements.

(Continued on next question...)

Other Job Interview Questions

• What is a thread?
• What is sqlcode -811?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What is COPY PENDING status?
• What do you accomplish by GROUP BY ... HAVING clause? ––
• Can I use LOCK TABLE on a view?
• What is the picture clause of the null indicator variable? –
• What are the various locks available?
• What do you mean by NOT NULL? When will you use it?
• What are correlated subqueries?
• More...