what happens when a filter is applied to a database

AAll records that don't meet the criteria are removed

BAll records that don't meet the criteria are permanently removed from the database

CSome records are permanently removed from the database

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