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
Bạn đang xem 17. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P59 PDF