Operators Flashcards

(28 cards)

1
Q

Comparison Operator <

A

less than

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

Comparison Operator >

A

greater than

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

Comparison Operator <=

A

less than or equal to

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

Comparison Operator >=

A

greater than or equal to

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

Comparison Operator =

A

equal

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

Comparison Operator <>

A

not equal

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

Comparison Operator !=

A

not equal ( != operator is converted to <> in the parser stage)

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

Name All Comparison Operators

A

< less than, > greater than, = greater than or equal to, = equal, <> or != not equal, BETWEEN greater than or equal to and lower than or equal to

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

Mathematical Operator +

A

addition

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

Mathematical Operator -

A

subtraction

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

Mathematical Operator *

A

multiplication

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

Mathematical Operator /

A

division (integer division truncates results)

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

Mathematical Operator %

A

modulo (remainder)

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

Mathematical Operator ^

A

exponentiation

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

Mathematical Operator |/

A

square root

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

Mathematical Operator ||/

17
Q

Mathematical Operator !

18
Q

Mathematical Operator !!

A

factorial (prefix operator)

19
Q

Mathematical Operator @

A

absolute value

20
Q

Mathematical Operator &

21
Q

Mathematical Operator |

22
Q

Mathematical Operator #

23
Q

Mathematical Operator ~

24
Q

Mathematical Operator «

A

bitwise shift left

25
Mathematical Operator >>
bitwise shift right
26
String Operator ||
Concatenation
27
Miscellaneous Operator ::
Cast. Historical, use CAST function instead
28
BETWEEN Construct
greater than or equal to and less than or equal to