Question

With _____, only one criterion must evaluate true in order for a record to be selected and with _____, all criteria must be evaluate true in order for a record to be selected.

a. parameter criteria, double criteria
b. function criteria, IF criteria
c. simple criteria, complex criteria
d. OR criteria, AND criteria

Answer 1

d

Step-by-step explanation:

OR criteria, AND criteria

In an OR criteria, it doesn't need all the records to be true. Just one record is enough and all other criterion becomes true.

In an AND criteria, it's unlike the OR criteria and works in opposite. It needs every member of the record to be true to be able to adjudge the whole record as true.

And as such, we have

With OR criteria, only one criterion must evaluate true in order for a record to be selected and with AND criteria, all criteria must be evaluate true in order for a record to be selected.