Operators

Question 1

Using the words / phrases below, what is the correct syntax for the Logical Operator “BETWEEN”:

• end_expression
• begin_expression
• AND
• [NOT]
• BETWEEN
• test_expression

Answer 1

Syntax:

test_expression [NOT] BETWEEN begin_expression AND end_expression

Question 2

Using the words / phrases below, what is the correct syntax for the Logical Operator “ALL”:

• ALL
• {= | <> | != | > | >= | !> | < | <= | !<}
• (subquery)
• scalar_expression

Answer 2

Syntax:

scalar_expression {= | <> | != | > | >= | !> | < | <= | !<} ALL (subquery)

Question 3

Using the words / phrases below, what is the correct syntax for the Logical Operator “AND”:

• AND
• boolean_expression
• boolean_expression

Answer 3

Syntax:

boolean_expression AND boolean_expression

Question 4

Using the words / phrases below, what is the correct syntax for the Logical Operator “SOME / ANY”:

• scalar_expression
• {= | <> | != | > | >= | !> | < | <= | !<}
• (subquery)
• {SOME | ANY}

Answer 4

Syntax:

scalar_expression {= | <> | != | > | >= | !> | < | <= | !<} {SOME | ANY} (subquery)

Question 5

Using the words / phrases below, what is the correct syntax for the Logical Operator “EXISTS”:

• (subquery)
• EXISTS

Answer 5

Syntax:

EXISTS (subquery)

Question 6

Using the words / phrases below, what is the correct syntax for the Logical Operator “IN”:

• IN
• (subquery | expression)
• test_expression
• [NOT]

Answer 6

Syntax:

test_expression [NOT] IN (subquery | expression)

Question 7

Using the words / phrases below, what is the correct syntax for the Logical Operator “LIKE”:

• [NOT]
• pattern
• LIKE
• match_expression
• [ESCAPE escape_character]

Answer 7

Syntax:

match_expression [NOT] LIKE pattern [ESCAPE escape_character]

Question 8

Using the words / phrases below, what is the correct syntax for the Logical Operator “NOT”:

• [NOT]
• boolean_expression

Answer 8

Syntax:

[NOT] boolean_expression

Question 9

Using the words / phrases below, what is the correct syntax for the Logical Operator “OR”:

• OR
• boolean_expression
• boolean_expression

Answer 9

Syntax:

boolean_expression OR boolean_expression

Question 10

Using the words / phrases below, what is the correct syntax for the Arithmetic Operator “+” (Add):

• +
• expression
• expression

Answer 10

Syntax:

expression + expression

Question 11

Using the words / phrases below, what is the correct syntax for the Arithmetic / Compound Operator “+=” (Add Equals):

• expression
• expression
• +=

Answer 11

Syntax:

expression += expression

Question 12

Using the words / phrases below, what is the correct syntax for the Arithmetic Operator “-“ (Subtract):

• -
• expression
• expression

Answer 12

Syntax:

expression - expression

Question 13

Using the words / phrases below, what is the correct syntax for the Arithmetic / Compound Operator “-=” (Subtract Equals):

• -=
• expression
• expression

Answer 13

Syntax:

expression -= expression

Question 14

Using the words / phrases below, what is the correct syntax for the Arithmetic Operator “*” (Multiply):

• *
• expression
• expression

Answer 14

Syntax:

expression * expression

Question 15

Using the words / phrases below, what is the correct syntax for the Arithmetic / Compound Operator “*=” (Multiply Equals):

• expression
• *=
• expression

Answer 15

Syntax:

expression *= expression

Question 16

Using the words / phrases below, what is the correct syntax for the Arithmetic Operator “/” (Divide):

• expression
• expression
• /

Answer 16

Syntax:

expression / expression

Question 17

Using the words / phrases below, what is the correct syntax for the Arithmetic / Compound Operator “/=” (Divide Equals):

• expression
• /=
• expression

Answer 17

Syntax:

expression /= expression

Question 18

Using the words / phrases below, what is the correct syntax for the Arithmetic Operator “%” (Modulo):

• divisor
• %
• dividend

Answer 18

Syntax:

dividend % divisor

Question 19

Using the words / phrases below, what is the correct syntax for the Arithmetic / Compound Operator “%=” (Modulo Equals):

• %=
• expression
• expression

Answer 19

Syntax:

expression %= expression

Question 20

Using the words / phrases below, what is the correct syntax for the Assignment Operator “=” (Equals):

• {variable | column_heading | database}
• expression
• =

Answer 20

Syntax:

{variable | column_heading | database} = expression

Question 21

Using the words / phrases below, what is the correct syntax for the Bitwise Operator “&” (Bitwise And):

• expression
• &
• expression

Answer 21

Syntax:

expression & expression

Question 22

Using the words / phrases below, what is the correct syntax for the Bitwise / Compound Operator “&=” (Bitwise And Equals):

• &=
• expression
• expression

Answer 22

Syntax:

expression &= expression

Question 23

Using the words / phrases below, what is the correct syntax for the Bitwise Operator “|” (Bitwise Or):

• expression
• expression
• |

Answer 23

Syntax:

expression | expression

Question 24

Using the words / phrases below, what is the correct syntax for the Bitwise / Compound Operator “|=” (Bitwise Or Equals):

• expression
• expression
• |=

Answer 24

Syntax:

expression |= expression

Question 25

Using the words / phrases below, what is the correct syntax for the Bitwise Operator "^" (Bitwise Exclusive Or): * ^ * expression * expression

Answer 25

Syntax: expression ^ expression

Question 26

Using the words / phrases below, what is the correct syntax for the Bitwise / Compound Operator "^=" (Bitwise Exclusive Or Equals): * ^= * expression * expression

Answer 26

Syntax: expression ^= expression

Question 27

Using the words / phrases below, what is the correct syntax for the Bitwise Operator "~" (Bitwise Not): * ~ * expression

Answer 27

Syntax: ~ expression

Question 28

Using the words / phrases below, what is the correct syntax for the Comparison Operator "=" (Equals): * = * expression * expression

Answer 28

Syntax: expression = expression

Question 29

Using the words / phrases below, what is the correct syntax for the Comparison Operator "\>" (Greater Than): * expression * expression * \>

Answer 29

Syntax: expression \> expression

Question 30

Using the words / phrases below, what is the correct syntax for the Comparison Operator "\<" (Less Than): * \< * expression * expression

Answer 30

Syntax: expression \< expression

Question 31

Using the words / phrases below, what is the correct syntax for the Comparison Operator "\>=" (Greater Than Or Equal To): * expression * expression * \>=

Answer 31

Syntax: expression \>= expression

Question 32

Using the words / phrases below, what is the correct syntax for the Comparison Operator "\<=" (Less Than Or Equal To): * \<= * expression * expression

Answer 32

Syntax: expression \<= expression

Question 33

Using the words / phrases below, what is the correct syntax for the Comparison Operator "\<\>" (Not Equal To): * expression * expression * \<\>

Answer 33

Syntax: expression \<\> expression

Question 34

Using the words / phrases below, what is the correct syntax for the Comparison Operator "!\<" (Not Less Than): * expression * expression * !\<

Answer 34

Syntax: expression !\< expression

Question 35

Using the words / phrases below, what is the correct syntax for the Comparison Operator "!=" (Not Equal To) * expression * != * expression

Answer 35

Syntax: expression != expression

Question 36

Using the words / phrases below, what is the correct syntax for the Comparison Operator "!\>" (Not Greater Than) * !\> * expression * expression

Answer 36

Syntax: expression !\> expression

Question 37

Using the words / phrases below, what is the correct syntax for the Scope Resolution Operator "::" * static members * compound data type * ::

Answer 37

Syntax: compound data type :: static members

Question 38

Using the words / phrases below, what is the correct syntax for the Set Operator "EXCEPT" * {query\_specification | (query\_expression)} * EXCEPT * {query\_specification | (query\_expression)}

Answer 38

Syntax: {query\_specification | (query\_expression)} EXCEPT {query\_specification | (query\_expression)}

Question 39

Using the words / phrases below, what is the correct syntax for the Set Operator "INTERSECT" * {query\_specification | (query\_expression)} * {query\_specification | (query\_expression)} * INTERSECT

Answer 39

Syntax: {query\_specification | (query\_expression)} INTERSECT {query\_specification | (query\_expression)}

Question 40

Using the words / phrases below, what is the correct syntax for the Set Operator "UNION" * {query\_specification | (query\_expression)} * UNION * {query\_specification | (query\_expression)}

Answer 40

Syntax: {query\_specification | (query\_expression)} UNION {query\_specification | (query\_expression)}

Question 41

Using the words / phrases below, what is the correct syntax for the String Operator "+" (String Concatenation): * expression * expression * +

Answer 41

Syntax: expression + expression

Question 42

Using the words / phrases below, what is the correct syntax for the String Operator "+=" (String Concatenation Equals): * expression * expression * +=

Answer 42

Syntax: expression += expression

Question 43

Using the words / phrases below, what is the correct syntax for the String Operator "%" (Percent Character): * [expression] * ' * ' * % * [expression]

Answer 43

Syntax: ' [expression] % [expression] '

Question 44

Using the words / phrases below, what is the correct syntax for the String Operator "[]" (Bracket Characters): * [ * [character] * [character] * ] * ' * - * '

Answer 44

Syntax: '[[character] - [character] ]'