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:

Delusional

A false belief held with strong conviction despite superior evidence to the contrary, often a symptom of psychiatric disorders.

Mental Abilities

The intellectual capacities and cognitive functions that enable problem solving, reasoning, and learning.

Old Age

The latter part of life, typically considered to begin at retirement age, characterized by a decline in physical and sometimes mental capabilities.

Brain Changes

Alterations in the structure, function, or chemistry of the brain due to various factors such as learning, aging, or injury.