Comparing Values Quiz

What is the order of Boolean Expression of Evaluation for where and eval commands? AND, OR, NOT, Expressions with parenthesis NOT, AND, OR, Expressions with parenthesis AND, NOT, Expressions with parenthesis, OR Expressions with parenthesis, NOT, AND, OR

Expressions with parenthesis, NOT, AND, OR

True or False: Specify a wildcard by using the * character with the where command. FALSE TRUE

FALSE

True or False: eval cannot exist as an expression.

FALSE

The where command only returns results that evaluate to TRUE. TRUE FALSE

TRUE

True of False: When using the eval command, all field values are treated in a case-sensitive manner and must be double-quoted. FALSE TRUE

TRUE

True or False: Temporary fields created by using eval can be referenced in the search pipeline following creation. FALSE TRUE

TRUE

The eval command calculates an expression and puts the resulting ____ into a new or existing field. Argument Command Value

Value

Which are the Boolean operators that can be used by the eval command? Select all that apply. XOR AND NAND OR

XOR AND OR

Which of the following functions must be used with the in function? Select all that apply. sum case validate if

case if

The where command interprets unquoted or single-quoted strings as _____ and double-quoted strings as _____. integers, field values field values, fields field values, integers field, field values

field, field values

Which of the following functions can be used to filter null values? usenull=t isnull usenull=f isnotnull

isnull isnotnull