An Organization Stores the Details of Its Employees Using Microsoft

question 28

Multiple Choice

An organization stores the details of its employees using Microsoft 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:

Egocentrism

A cognitive trait where an individual is unable to differentiate between their own perspective and that of others, often observed in children.

Abstract Thought

Abstract thought is the ability to think about objects, principles, and ideas that are not physically present, involving complex processes such as problem-solving and theorizing.

Centration

A cognitive limitation in early childhood, where a child focuses only on one aspect of a situation and ignores other relevant aspects.

Animism

The belief that objects, places, and creatures all possess a distinct spiritual essence or soul.