Comparing Values Flashcards

1
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The ___ command replaces NULL values in fields.

  • isnotnull
  • fillnull
  • isnull
  • null
A

fillnull

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

  • XOR
  • NAND
  • OR
  • AND
A

XOR
OR
AND

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which of these fillnull expressions will replace NULL data with the string “NOT FOUND”?

  • | fillnull
  • | fillnull value=”NOT FOUND”
  • | fillnull NOTFOUND
  • | fillnull NOTFOUND=true
A

fillnull value=”NOT FOUND”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

  • FALSE
  • TRUE
A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The where command only returns results that evaluate to TRUE.

  • TRUE
  • FALSE
A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

  • argument
  • command
  • value
A

value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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
A

fields, field values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

True or False: The case function will return NULL if no expressions evaluate to TRUE.

FALSE
TRUE

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

True or False: eval cannot exist as an expression.

  • TRUE
  • FALSE
A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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
A

Expressions with parenthesis, NOT, AND, OR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which eval function is the best option for masking data?

  • replace
  • isnotnull
  • case
  • validate
A

replace

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

  • sum
  • validate
  • case
  • if
A

case
if

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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
A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following functions can be used to filter NULL values?

usenull=t
usenull=f
isnull
isnotnull

A

isnull
isnotnull

How well did you know this?
1
Not at all
2
3
4
5
Perfectly