What does NOT do in compound criteria?

What does NOT do in compound criteria?

• A. Expands the result set by including similar records
• B. Requires all criteria
• C. Includes at least one criterion
• D. Excludes specified items

Answer: (D)

Compound criteria describe how multiple filters are combined to decide which records to include. When you use OR to connect criteria, the result set expands because a record that meets any one of the conditions is kept. Requiring all criteria uses AND logic, narrowing the results since every condition must be satisfied. Saying that you include at least one criterion is essentially the same idea as allowing any one of the conditions to be true. Excluding specified items is a negation step that removes records from the results rather than defining which records to include based on positive conditions. In this context, exclusion isn’t part of the core function of compound criteria, which is about including records that meet the combined criteria rather than explicitly filtering out items.

Compound criteria describe how multiple filters are combined to decide which records to include. When you use OR to connect criteria, the result set expands because a record that meets any one of the conditions is kept. Requiring all criteria uses AND logic, narrowing the results since every condition must be satisfied. Saying that you include at least one criterion is essentially the same idea as allowing any one of the conditions to be true. Excluding specified items is a negation step that removes records from the results rather than defining which records to include based on positive conditions. In this context, exclusion isn’t part of the core function of compound criteria, which is about including records that meet the combined criteria rather than explicitly filtering out items.