Craig Is Working in a Database That Stores Homes for Sale

question 57

Multiple Choice

Craig is working in a database that stores homes for sale for a Realtor. The database contains a table called HomeListings which contains a field called ListingDate that holds the date that a home was listed. Craig is designing a query that will identify houses on the market for less than 30 days as new listings, and houses on the market 30 days or more as old listings. This information will be included in a query column called ListingAge. Which of the following expressions will achieve these results:

• A) ListingAge: IIf(Date-[HomeListings]![ListingDate]<30,"New Listing","Old Listing")
• B) ListingAge: IIf(Date-[HomeListings]![ListingDate]>30,"New Listing","Old Listing")
• C) ListingAge: IIf(Date-[HomeListings]![ListingDate] < 30, "Old Listing","New Listing")
• D) ListingAge: IIf(Date-[ListingDate]![HomeListings]<30,"New Listing","Old Listing")

---

Definitions:

Equal Opportunities

Policies and practices designed to ensure that individuals are treated fairly and equitably, without discrimination based on characteristics such as race, gender, disability, or age.

Protected Classes

Groups of people who are legally protected from discrimination and harassment in the workplace, housing, education, and other areas based on specific characteristics such as race, religion, gender, and more.

Equity Theory

Equity Theory suggests that individuals seek fairness in relationships, feeling satisfied when they perceive that their inputs and outcomes are proportional to those of their comparison others.

Continuance Commitment

Commitment that results when an employee remains with a company because of the high cost of losing organizational membership including monetary and social costs.