
MySQL Commands in English
Authored by Nelly Granada
Professional Development
11th Grade
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the command to create a new database in MySQL?
ADD DATABASE database_name;
CREATE DATABASE database_name;
CREATE TABLE database_name;
INSERT INTO database_name;
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you display all databases in MySQL?
DISPLAY DATABASES;
LIST DATABASES;
VIEW DATABASES;
SHOW DATABASES;
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the command to create a new table in MySQL?
ADD TABLE table_name (column1 datatype, column2 datatype, ...);
INSERT INTO table_name (column1 datatype, column2 datatype, ...);
CREATE TABLE table_name (column1 datatype, column2 datatype, ...);
CREATE NEW table_name (column1 datatype, column2 datatype, ...);
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you show the structure of a table in MySQL?
DESCRIBE users;
SHOW TABLE users;
VIEW users;
DISPLAY users;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the command to insert data into a table in MySQL?
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
INSERT INTO table_name VALUES (value1, value2, ...);
ADD INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
INSERT table_name (column1, column2, ...) VALUES (value1, value2, ...);
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you update data in a table in MySQL?
UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
CHANGE table_name SET column1 = value1, column2 = value2 WHERE condition;
INSERT INTO table_name VALUES (value1, value2);
MODIFY table_name SET column1 = value1, column2 = value2 WHERE condition;
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the command to delete a table in MySQL?
REMOVE TABLE table_name;
DROP TABLE table_name;
DROP DATABASE table_name;
DELETE TABLE table_name;
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?