Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Transact SQL > Operators > Flashcards

Operators Flashcards

1
Q

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

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

Syntax:

test_expression [NOT] BETWEEN begin_expression AND end_expression

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

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

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

Syntax:

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

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

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

  • AND
  • boolean_expression
  • boolean_expression
A

Syntax:

boolean_expression AND boolean_expression

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

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

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

Syntax:

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

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

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

  • (subquery)
  • EXISTS
A

Syntax:

EXISTS (subquery)

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

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

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

Syntax:

test_expression [NOT] IN (subquery | expression)

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

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

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

Syntax:

match_expression [NOT] LIKE pattern [ESCAPE escape_character]

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

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

  • [NOT]
  • boolean_expression
A

Syntax:

[NOT] boolean_expression

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

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

  • OR
  • boolean_expression
  • boolean_expression
A

Syntax:

boolean_expression OR boolean_expression

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

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

  • +
  • expression
  • expression
A

Syntax:

expression + expression

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

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

  • expression
  • expression
  • +=
A

Syntax:

expression += expression

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

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

  • -
  • expression
  • expression
A

Syntax:

expression - expression

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

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

  • -=
  • expression
  • expression
A

Syntax:

expression -= expression

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

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

  • *
  • expression
  • expression
A

Syntax:

expression * expression

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

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

  • expression
  • *=
  • expression
A

Syntax:

expression *= expression

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

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

  • expression
  • expression
  • /
A

Syntax:

expression / expression

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

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

  • expression
  • /=
  • expression
A

Syntax:

expression /= expression

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

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

  • divisor
  • %
  • dividend
A

Syntax:

dividend % divisor

19
Q

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

  • %=
  • expression
  • expression
A

Syntax:

expression %= expression

20
Q

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

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

Syntax:

{variable | column_heading | database} = expression

21
Q

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

  • expression
  • &
  • expression
A

Syntax:

expression & expression

22
Q

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

  • &=
  • expression
  • expression
A

Syntax:

expression &= expression

23
Q

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

  • expression
  • expression
  • |
A

Syntax:

expression | expression

24
Q

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

  • expression
  • expression
  • |=
A

Syntax:

expression |= expression

25
Q

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

  • expression
  • expression
A

Syntax:

expression ^ expression

26
Q

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

  • ^=
  • expression
  • expression
A

Syntax:

expression ^= expression

27
Q

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

  • ~
  • expression
A

Syntax:

~ expression

28
Q

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

  • =
  • expression
  • expression
A

Syntax:

expression = expression

29
Q

Using the words / phrases below, what is the correct syntax for the Comparison Operator “>” (Greater Than):

  • expression
  • expression
  • >
A

Syntax:

expression > expression

30
Q

Using the words / phrases below, what is the correct syntax for the Comparison Operator “<” (Less Than):

  • <
  • expression
  • expression
A

Syntax:

expression < expression

31
Q

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

  • expression
  • expression
  • >=
A

Syntax:

expression >= expression

32
Q

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

  • <=
  • expression
  • expression
A

Syntax:

expression <= expression

33
Q

Using the words / phrases below, what is the correct syntax for the Comparison Operator “<>” (Not Equal To):

  • expression
  • expression
  • <>
A

Syntax:

expression <> expression

34
Q

Using the words / phrases below, what is the correct syntax for the Comparison Operator “!<” (Not Less Than):

  • expression
  • expression
  • !<
A

Syntax:

expression !< expression

35
Q

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

  • expression
  • !=
  • expression
A

Syntax:

expression != expression

36
Q

Using the words / phrases below, what is the correct syntax for the Comparison Operator “!>” (Not Greater Than)

  • !>
  • expression
  • expression
A

Syntax:

expression !> expression

37
Q

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

  • static members
  • compound data type
  • ::
A

Syntax:

compound data type :: static members

38
Q

Using the words / phrases below, what is the correct syntax for the Set Operator “EXCEPT”

  • {query_specification | (query_expression)}
  • EXCEPT
  • {query_specification | (query_expression)}
A

Syntax:

{query_specification | (query_expression)} EXCEPT {query_specification | (query_expression)}

39
Q

Using the words / phrases below, what is the correct syntax for the Set Operator “INTERSECT”

  • {query_specification | (query_expression)}
  • {query_specification | (query_expression)}
  • INTERSECT
A

Syntax:

{query_specification | (query_expression)} INTERSECT {query_specification | (query_expression)}

40
Q

Using the words / phrases below, what is the correct syntax for the Set Operator “UNION”

  • {query_specification | (query_expression)}
  • UNION
  • {query_specification | (query_expression)}
A

Syntax:

{query_specification | (query_expression)} UNION {query_specification | (query_expression)}

41
Q

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

  • expression
  • expression
  • +
A

Syntax:

expression + expression

42
Q

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

  • expression
  • expression
  • +=
A

Syntax:

expression += expression

43
Q

Using the words / phrases below, what is the correct syntax for the String Operator “%” (Percent Character):

  • [expression]
  • ’
  • ’
  • %
  • [expression]
A

Syntax:

’ [expression] % [expression] ‘

44
Q

Using the words / phrases below, what is the correct syntax for the String Operator “[]” (Bracket Characters):

  • [
  • [character]
  • [character]
  • ]
  • ’
  • -
  • ’
A

Syntax:

’[[character] - [character] ]’

Transact SQL (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions