Jen Is Working on a Database That Stores Employee Data

question 84

Multiple Choice

Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company more than ten years?

• A) >10
• B) #10#
• C) =>10
• D) <>10

---

Definitions:

Front-end Loads

Charges or fees that are paid by investors at the time of purchasing shares of a mutual fund or an investment trust.

Low-load Mutual Funds

Mutual funds that charge a lower sales load (commission) compared to typical sales charges, making them more cost-effective for investors.

Asset Value

Asset value is the total value of a company's or individual's assets, calculated by summing the market value of all tangible and intangible items.

Net Asset Value

The total value of a fund's assets minus its liabilities, often used in the context of mutual and exchange-traded funds.