The ____ object is responsible for retrieving the appropriate information from the database and storing it in the DataSet.

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-[ListingDate]![HomeListings]<30,"New Listing","Old Listing") B) ListingAge: IIf(Date-[HomeListings]![ListingDate]>30,"New Listing","Old Listing") C) ListingAge: IIf(Date-[HomeListings]![ListingDate]<30,"New Listing","Old Listing") D) ListingAge: IIf(Date-[HomeListings]![ListingDate] < 30, "Old Listing","New Listing")

A problem with pattern-matching is synonyms. If the current directory is bin and . denotes the current directory and .. its parent, then bin, ../bin, ../bin/., .././bin/../bin all denote the same directory. If you are trying to block access to the bin directory in a command script, you need to consider all these variants (and an infinite number more). Cite a means by which a pattern matching algorithm copes with synonyms.

What will be an ideal response?