Week 3 - SQL

Question 1

Where does SQL stand for?

Answer 1

Structured Query Language

Question 1

Is SQL case sensitive?

Answer 1

NO (select = SELECT)
Table / Field names may be case
sensitive.

Question 2

Datatypes in MySQL can be broadly divided
into three categories:

Answer 2

Numeric
– Date Time
– String

Question 3

Numeric datatypes

Answer 3

• int, used for integer (whole) numbers
  – float, used for floating point (decimal) numbers

Question 4

Time-related datatypes

Answer 4

– date
– time
– datetime

Date format: “yyyy‐mm‐dd”
Time format: “hh:mm:ss”

Question 5

String datatypes

Answer 5

• char (bijv. always 3t)
  – varchar (bijv. 1-4b. Fourth b tells DBM that is has reached end of field —> therefore empty string required one b to store )
  – text (<255 characters)

char and varcharare good up to 255
characters