Introduction to MySQL

Question 1

Is an open-source relational database management system.

Answer 1

MySQL

Question 2

Where does “My” & “SQL” came from?

Answer 2

“My” from the name of co-founder Michael Widenius’s daughter.

“SQL” is the abbreviation of Structured Query Language.

Question 3

MySQL is written in what programming language?

Answer 3

C and C++

Question 4

MySQL was created by which Swedish company?

Answer 4

MySQL AB

Question 5

What is the star feature of MySQL?

Answer 5

On-demand flexibility

Question 6

Provide connectivity to the MySQL server for client programs.

Answer 6

MySQL Connectors

Question 7

Provide low-level access to MySQL resources using either the classic MySQL protocol or X Protocol.

Answer 7

APIs

Question 8

Is a cache of database connections maintained so that the connections can be reused when future requests to the database are required.

Answer 8

MySQL Connection pool

Question 9

Are used to enhance the performance of executing commands on a database.

Answer 9

Connection pool

Question 10

Allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface, and much more.

Answer 10

SQL Interface

Question 11

Translates the SQL command in textual format into a combination of internal binary structures that can be easily manipulated by the optimizer.

Answer 11

MySQL Parser

Question 12

Is built-in database software that determines the most efficient method for an SQL statement to access requested data.

Answer 12

Query optimizer (called simply the optimizer)

Question 13

Is an area in main memory where InnoDB caches table and index data as it is accessed.

Answer 13

Buffer pool

Question 14

Permits frequently used data to be accessed directly from memory, which speeds up processing. On dedicated servers, up to 80% of physical memory is often assigned to this.

Answer 14

Buffer pool

Question 15

Is a prominent MySQL feature that speeds up data retrieval from a database. It achieves this by storing MySQL SELECT statements together with the retrieved record set in memory, then if a client requests identical queries it can serve the data faster without executing commands again from the database.

Answer 15

Query cache

Question 16

The default storage engine in MySQL 8.0 and is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data.

Answer 16

InnoDB

Question 17

These tables have a small footprint so it is often used in read-only or read-mostly workloads in Web and data warehousing
configurations.

Answer 17

MyISAM

Question 18

Stores all data in RAM, for fast access in environments that require quick lookups of non-critical data. This engine was formerly known as the HEAP engine.

Answer 18

Memory

Question 19

Its tables are text files with comma-separated values.

Answer 19

CSV

Question 20

These compact, unindexed tables are intended for storing and retrieving large amounts of
seldom-referenced historical, archived, or security audit information.

Answer 20

Archive

Question 21

Accepts but does not store data, similar to the Unix /dev/null device. Queries always return an empty set. These tables can be used in replication configurations where DML statements are sent to replica servers, but the source server does not keep its own copy of the data.

Answer 21

Blackhole

Question 22

This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability.

Answer 22

NBD (or NBDCluster)