Zend
ZF-100-500 · Question #192
ZF-100-500 Question #192: Real Exam Question with Answer & Explanation
Sign in or unlock ZF-100-500 to reveal the answer and full explanation for question #192. The question stem and answer options stay visible for context.
Question
A table named employees is given below: Which of the following statements would return the employees names , in ascending order, based on their last name and first name? Each correct answer represents a complete solution . Choose all that apply.
Exhibit
Options
- Aselect fname, lname from employees order by lname;
- Bselect fname, lname from employees order by lname desc;
- Cselect fname, lname from employees group by lname;
- Dselect fname, lname from employees order by lname asc;
Unlock ZF-100-500 to see the answer
You've previewed enough free ZF-100-500 questions. Unlock ZF-100-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.