Zend
200-530 · Question #20
200-530 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock 200-530 to reveal the answer and full explanation for question #20. 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. Zend 200-530 Exam Choose all that apply.
Exhibit
Options
- Aselect fname, lname from employees order by lname;
- Bselect fname, lname from employees order by lname asc;
- Cselect fname, lname from employees group by lname;
- Dselect fname, lname from employees order by lname desc;
Unlock 200-530 to see the answer
You've previewed enough free 200-530 questions. Unlock 200-530 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.