Course 4: Module 3 Flashcards

1
Q

Float

A

A number that contains a decimal

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

CONCAT()

A

Adds strings together to create new text strings that can be used as unique keys

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

COALESCE()

A

Can be used to return non-null values in a list

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

CAST

A

A SQL function that converts data from one datatype to another

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

DISTINCT

A

A keyword that is added to a SQL SELECT statement to retrieve only non-duplicate entries

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

Substring

A

A subset of a text string

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

Typecasting

A

Converting data from one type to another

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