Question 1

Which keyword is used to add a new column to a MySQL table?

Accepted Answer

ALTER TABLE

Answer

CREATE COLUMN

Answer

INSERT COLUMN

Answer

ADD COLUMN

Question 2

Which keyword is used to update data in a MySQL table?

Accepted Answer

UPDATE

Answer

SELECT

Answer

DELETE

Answer

INSERT

Question 3

What is the command used to create a new database in MySQL?

Accepted Answer

CREATE DATABASE

Answer

MAKE DATABASE

Answer

DEFINE DATABASE

Answer

ALERT DATABASE

Question 4

Which keyword is used to retrieve data from a MySQL database?

Accepted Answer

SELECT

Answer

DELETE

Answer

INSERT

Answer

UPDATE

Question 5

Which MySQL command is used to modify a table?

Accepted Answer

ALTER TABLE

Answer

CHANGE TABLE

Answer

MODIFY TABLE

Answer

UPDATE TABLE

Question 6

What does SQL stand for?

Accepted Answer

Structured Query Language

Answer

System Query Language

Answer

Standard Query Language

Answer

Sequential Query Language

Question 7

What data type is used to store a whole number in MySQL?

Accepted Answer

INTEGER

Answer

BOOLEAN

Answer

STRING

Answer

FLOAT

Question 8

What is the primary key in a MySQL table?

Accepted Answer

A unique identifier for each record in the table

Answer

The first column in a table

Answer

A key that provides extra security

Answer

A column that stores numeric values

Question 9

What does the keyword 'WHERE' do in a MySQL query?

Accepted Answer

Filters the results based on specified conditions

Answer

Joins two or more tables together

Answer

Orders the results in ascending order

Answer

Deletes specified records from a table

Question 10

Which keyword is used to add new records to a MySQL table?

Accepted Answer

INSERT

Answer

DELETE

Answer

SELECT

Answer

UPDATE

Question 11

What does the SQL keyword 'UPDATE' do?

Accepted Answer

Modifies existing records in a MySQL table

Answer

Creates a new table in the database

Answer

Deletes specified records from a table

Answer

Inserts new records into a table

Question 12

What does the SQL keyword 'DELETE' do?

Accepted Answer

Deletes specified records from a table

Answer

Modifies existing records in a MySQL table

Answer

Inserts new records into a table

Answer

Creates a new table in the database

Question 13

What does the SQL keyword 'JOIN' do in a MySQL query?

Accepted Answer

Combines rows from multiple tables based on a related column

Answer

Filters the results based on specified conditions

Answer

Deletes specified records from a table

Answer

Orders the results in ascending order

Question 14

What is the SQL keyword used to create a new table in a MySQL database?

Accepted Answer

CREATE

Answer

UPDATE

Answer

INSERT

Answer

SELECT

Question 15

What is the syntax for inserting data into a MySQL table?

Accepted Answer

INSERT INTO

Answer

SET INTO

Answer

PUT INTO

Answer

ADD INTO

Question 16

Which MySQL command is used to retrieve multiple tables of data?

Accepted Answer

JOIN

Answer

UNION

Answer

COMBINE

Answer

MERGE

Related quizzes

Related quizzes