MySQL Basics Practice Test: Basic MySQL Use — Flashcards

Quiz questions on basic database terminology, MySQL setup,  and Interacting with MySQL.

MySQL is an open-source relational database management system (RDBMS) that allows users to create, manage, and retrieve data in tables. It uses structured query language (SQL) to store data in tables that map to objects. Each table has a schema that defines what columns each row will have. Developers can store and retrieve many data types, including text, numbers, dates, times, and even JSON. 

MySQL is used in a variety of applications, including small-scale projects, large-scale websites, and enterprise-level solutions. It is compatible with all major computing platforms, including Unix-based operating systems, Mac OS, and Windows. MySQL is known for its reliability, scalability, and ease of use. 

Here are some basics of MySQL:
Data structure: MySQL stores data in tables that map to objects.
Tables: MySQL databases contain records in multiple, separate, and highly codified tables.
Schema: Each table has a schema defining what columns each row of the table will have.
SQL: MySQL uses SQL to create, modify, and extract data from the relational database. SQL is the most popular language for adding, accessing, and managing content in a database.
Normalization: MySQL normalizes data in the rows and columns of the tables, making it a scalable yet flexible data storage system.
Referential Integrity: MySQL provides the Referential Integrity between rows or columns of various tables.
Table indexes: MySQL automatically updates the table indexes.