MySQL Basics for Students

What is the purpose of MySQL?

• To manage user authentication and authorization.

• To perform complex mathematical calculations.

• To create and design websites.

• The purpose of MySQL is to manage and organize data in a relational database.

Which data type is used to store whole numbers in MySQL?

• BOOLEAN

• FLOAT

• INT

• VARCHAR

What does DDL stand for in the context of databases?

• Data Delivery Logic

• Data Distribution Layer

• Data Definition Language

• Data Design Language

Which command is used to create a new table in MySQL?

• INSERT TABLE

• ADD TABLE

• CREATE TABLE

• MODIFY TABLE

What is the purpose of the VARCHAR data type?

• To store numeric values in a database.

• To store date and time values in a database.

• To store variable-length strings in a database.

• To store fixed-length strings in a database.

What does DML stand for?

• Data Manipulation Language

• Data Management Language

• Data Modeling Language

• Database Manipulation Language

Which command is used to insert data into a table?

• UPDATE SET

• ADD TO

• REMOVE FROM

• INSERT INTO

What is a primary key?

• A primary key can have duplicate values.

• A primary key is a unique identifier for a record in a database table.

• A primary key is a type of foreign key.

• A primary key is used to store images in a database.

What is the purpose of a foreign key?

• To store data in a single table without relationships.

• To create a new table in the database.

• The purpose of a foreign key is to maintain referential integrity between two related tables.

• To delete records from a table.

Which command is used to delete data from a table?

• ERASE

• DELETE

• REMOVE

• CLEAR