An Organization Stores the Details of Its Employees Using Access

question 3

Multiple Choice

An organization stores the details of its employees using Access: The Employee table has EmployeeName,EmployeeID,Department,and Salary columns: Which of the following statements is true?

• A) To view the average salary drawn by the employees of each department, the Group By option should be selected in the Total row under Salary.
• B) To count the number of employees in each department, the Group By option should be selected under EmployeeID and the Count option under Department.
• C) To find the sum of salaries drawn by the employees of each department, the Group By option should be selected under Department and Sum under Salary.
• D) To count the number of employees having the same salary, the Group By option should be selected under EmployeeID and Count under Salary.

---

Definitions:

Perilymph

The fluid that fills the space between the membrane lining the bony labyrinth and the membranous labyrinth of the inner ear, aiding in hearing and balance.

Superior Olivary Nucleus

A collection of neurons in the brainstem involved in auditory processing, particularly in the localization of sound sources.

High-Pitched Tones

Sounds that have a high frequency, perceived by the ear as sharp, squeaky, or shrill.

Spiral Organ

A sensory structure within the cochlea of the inner ear responsible for converting sound vibrations into neural signals.