STUDY THIS STATEMENT

17. Study this statement:

select ename from emp union all select ename from ex_emp;

In what order will the rows be returned? (Choose the best answer.)

A. The rows from each table will be grouped and within each group will be

sorted on ENAME.

B. The rows from each table will be grouped but not sorted.

C. The rows will not be grouped, but will all be sorted on ENAME.

D. The rows will be neither grouped nor sorted.

Self Test Answers

P AR T II