The SQL Query to Output the Contents of the EMPLOYEE

question 55

Multiple Choice

The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is _____.

• A) SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
• B) SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
• C) SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
• D) SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

---

Definitions:

Deviant Activities

Behaviors that violate the norms or accepted standards of a society or community, which can range from minor infractions to serious crimes.

Crimes

Acts or omissions that violate laws which have been established by governmental authorities and are punishable by the state.

Critical Legal Scholars

A movement in legal thought that challenges and seeks to change mainstream legal practices and institutions, emphasizing the role of law in perpetuating social inequalities.

Power

A social or political force exerted by entities such as individuals, groups, or institutions to achieve their objectives, often through control or dominance.