What happens when a filter is applied to a database?

Question

(1 point)
Responses

All records that don’t meet the criteria are removed from view.
All records that don’t meet the criteria are removed from view.

All records that don’t meet the criteria are permanently removed from the database.
All records that don’t meet the criteria are permanently removed from the database.

Some records are permanently removed from the database.
Some records are permanently removed from the database.

Records that meet the criteria are moved to the top of the database and highlighted.

Answer 1

When a filter is applied to a database, the correct response is:

All records that don’t meet the criteria are removed from view.

Filters allow users to narrow down the displayed results to only those that meet specific conditions, but the other records remain intact in the database. They are simply not visible until the filter is removed.