Microsoft
98-364 · Question #116
98-364 Question #116: Real Exam Question with Answer & Explanation
Sign in or unlock 98-364 to reveal the answer and full explanation for question #116. The question stem and answer options stay visible for context.
Question
Roger is the HR Manager of Neon Inc. He wants to generate a report of all the employees working in Department ID 30 from the Emp table on the following attributes: - Fname - Lname - Salary All the records should be sorted in ascending order of the Lname attribute. Which of the following queries will he use to get the required output?
Options
- ASELECT Fname Lname Salary FROM Emp WHERE DeptId=30 ORDER BY Lname
- BSELECT Fname, Lname, Salary FROM Emp ORDER BY Lname WHERE DeptId=30
- CSELECT Fname Lname Salary FROM Emp ORDER BY Lname WHERE DeptId=30
- DSELECT Fname, Lname, Salary FROM Emp WHERE DeptId=30 ORDER BY Lname
Unlock 98-364 to see the answer
You've previewed enough free 98-364 questions. Unlock 98-364 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.