Data Types

Question 1

Three main data types

Answer 1

Numeric , Date and Time , String

Can be considered domain types, governed by the nature of the data and how it’s manipulated

Question 2

Can users input text into a numeric field

Answer 2

No, intelligent use of data types validates data entry
Data type controls what can be done with the information
A numeric value can be added to a string (varchar)

Question 3

What is numeric?

Answer 3

A number field with or without decimal points

Question 4

Data types Date and Time

Answer 4

Datetime - YYYY-MM‐DD HH:MM:SS
Date - YYYY-MM-DD
Timestamp YYYYMMDDHHMMSS
Time - HH:MM:SS
Year - YYYY

Question 5

Data type String

Answer 5

CHAR - Fixed length string
VARCHAR - Variable length string
BLOB - Binary Large OBject
TEXT , TINYBLOB , TINYTEXT , MEDIUM BLOB

Question 6

What is BLOB

Answer 6

Collection of binary data such as images, audio, or other multimedia (search is case sensitive)

Question 7

Is TEXT similar to BLOB?

Answer 7

Yes, except searching is case insensitive