Question

In database terminology, when performing a query, the specified conditions involve comparing values in 1 (col1) and 2 (col2), where the _3 (vals) meet the specified 4 (collect).

Option 1: columns
Option 2: predicates
Option 3: values
Option 4: criteria

Answer 1

When performing a database query, the specified conditions involve comparing values in columns 1 and 2, where the values meet the specified criteria.

Step-by-step explanation:

In database terminology, when performing a query, the specified conditions involve comparing values in column 1 (col1) and column 2 (col2), where the values meet the specified criteria (option 4).

For example, if we want to retrieve all the records where the value in col1 is greater than the value in col2, we would specify the condition as col1 > col2.

Therefore, the correct option in this context is Option 4: criteria.