Comparing Values Flashcards
True or False: Temporary fields created by using eval can be referenced in the search pipeline following creation.
True
The ___ command replaces NULL values in fields.
- isnotnull
- fillnull
- isnull
- null
fillnull
Which are the Boolean operators that can be used by the eval command? Select all that apply.
- XOR
- NAND
- OR
- AND
XOR
OR
AND
Which of these fillnull expressions will replace NULL data with the string “NOT FOUND”?
- | fillnull
- | fillnull value=”NOT FOUND”
- | fillnull NOTFOUND
- | fillnull NOTFOUND=true
fillnull value=”NOT FOUND”
True or False: Specify a wildcard by using the * character with the where command.
- FALSE
- TRUE
False
The where command only returns results that evaluate to TRUE.
- TRUE
- FALSE
True
The eval command calculates an expression and puts the resulting ____ into a new or existing field.
- argument
- command
- value
value
The where command interprets unquoted or single-quoted strings as _____ and double-quoted strings as _____.
- integers, field values
- fields, field values
- field values, integers
- field values, fields
fields, field values
True or False: The case function will return NULL if no expressions evaluate to TRUE.
FALSE
TRUE
True
True or False: eval cannot exist as an expression.
- TRUE
- FALSE
False
What is the order of Boolean Expression of Evaluation for the where and eval commands?
- AND, OR, NOT, Expressions with parenthesis
- NOT, AND, OR, Expressions with parenthesis
- Expressions with parenthesis, NOT, AND, OR
- AND, NOT, Expressions with parenthesis, OR
Expressions with parenthesis, NOT, AND, OR
Which eval function is the best option for masking data?
- replace
- isnotnull
- case
- validate
replace
Which of the following functions must be used with the in function? Select all that apply.
- sum
- validate
- case
- if
case
if
True of False: When using the eval command, all field values are treated in a case-sensitive manner and must be double-quoted.
- TRUE
- FALSE
True
Which of the following functions can be used to filter NULL values?
usenull=t
usenull=f
isnull
isnotnull
isnull
isnotnull