MySQL Flashcards

(27 cards)

1
Q

What is MySQL?

A

An object-relational database management system

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

Who originally developed MySQL?

A

A Swedish company, MySQL AB, A Swedish company, MySQL AB, initially developed MySQL, naming it after My, the daughter of co-founder Monte Widenius

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

Who is MySQL named after?

A

My, daughter of Monty Widenius

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

Which companies acquired MySQL?

A

Sun Microsystems then Oracle

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

What is the MySQL logo dolphin called?

A

Sakila

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

What is the LAMP stack?

A

Linux, Apache, MySQL, PHP

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

Why did MySQL become popular in the 1990s?

A

LAMP stack web development

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

What licenses does MySQL use?

A

GNU GPL and commercial

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

What is MariaDB?

A

A fork of MySQL

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

Which operating systems support MySQL?

A

Linux, UNIX, Windows

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

What language does MySQL use?

A

SQL with extensions

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

What does LOAD DATA do?

A

Imports data from text files

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

What types of data does MySQL support?

A

Relational and JSON

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

What is a storage engine?

A

A component that manages table data and SQL operations

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

What is the default MySQL storage engine?

A

InnoDB

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

What features does InnoDB provide?

A

Transactions, row locking, foreign keys

17
Q

What is MyISAM best for?

A

Read-heavy workloads

18
Q

What locking method does MyISAM use?

A

Table-level locking

19
Q

What is the NDB engine used for?

A

MySQL clustering

20
Q

What is replication?

A

Copying data to replicas

21
Q

Why use replication?

A

Read scalability and failover

22
Q

What is clustering?

A

Multiple servers working as one system

23
Q

What are MySQL clustering options?

A

InnoDB group replication and NDB cluster

24
Q

What does MySQL Router do?

A

Load balancing and failover routing

25
What does MySQL Cluster Edition use?
NDB storage engine
26
Where is data stored in NDB clusters?
In memory on data nodes
27
What benefit does clustering provide?
High availability and scalability