MySQL

Question 1

What is SQL?

Answer 1

Structured Query Language. A language used for storing, retrieving and manipulating data in a relational database.

Question 2

What is MySql?

Answer 2

A popular, open source, database. Think of MySQL as a brand of SQL database.

Question 3

What is ERD?

Answer 3

An Entity Relationship Diagram. A visual representation of how your database looks and behaves.

Question 4

What is a Primary Key?

Answer 4

A database column designated to uniquely identify each table record.

Question 5

What type of data is an INT?

Answer 5

A number. In MySQL an INT can be between -2147483648 to 2147483647 for a signed integer or 0 and 4294967295 for unsigned.

Question 6

What type of data is an VARCHAR? What does the 255 represent?

Answer 6

A VARCHAR is a string, 255 is the maximum length of that string.

Question 7

What type of data is DATETIME?

Answer 7

It stores date and time information in the form of a string.

Question 8

Why is MySQL referred to a relational database?

Answer 8

Because we can store relationships between tables.

Question 9

What types of relationships exists?

Answer 9

One to One
One to Many
Many to Many
Self Join

Question 10

What is a Foreign Key?

Answer 10

It’s used to link two tables together. It is the same number as the Primary Key of the row of data in the related table.