Question

The ____________________ logical operator is used to combine search conditions that must both be TRUE to include a row in the results of a query.

A) OR
B) XOR
C) AND
D) NOT

Answer 1

The logical operator used to combine search conditions that both need to be TRUE for a query is AND.

Step-by-step explanation:

The logical operator used to combine search conditions that must both be TRUE to include a row in the results of a query is C) AND. This operator is critical in narrowing down search results to the most relevant information by ensuring that all combined search terms are present in the resulting sources. For instance, using a search string like 'artificial intelligence' AND 'innovation' AND '2021' will return documents that contain all three specified terms, hence making the search results more specific and manageable.