Complete Data Type List Flashcards by Flannery White-Domain | Brainscape

Q

Bit

A

0 or 1

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

TinyInt

A

1 byte

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

SmallInt

A

2 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Int

A

4 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

BigInt

A

8 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Numeric

A

Varies

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Decimal

A

Varies

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

SmallMoney

A

4 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Money

A

8 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

DateTime

A

8 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

SmallDateTime

A

4 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Date

A

3 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Time

A

5 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

DateTimeOffset

A

10 bytes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

DateTime2

A

Varies

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Char

A

Varies

Q

VarChar (MAX)

A

BLOB

Q

nChar

A

Varies

Q

nVarChar

A

Varies

Q

nVarChar (MAX)

A

BLOB

Q

Binary

A

Varies

Q

VarBinary

A

Varies

Q

Image

A

BLOB

Q

Uniqueidentifier

A

16 bytes

Q

1NF

A

Eliminate Repeating Groups

Q

2NF

A

Eliminate Redundant Data

Q

3NF

A

Eliminate Non-Dependent Columns

Q

4NF

A

No Independent Multiple Relationships

Q

5NF

A

Isolate Semantically Related Relationships