MySQL Tournament

Basic Command 1

100

This command is used to create a new database. What is it?

A) CREATE TABLE
B) CREATE DATABASE
C) INSERT INTO
D) DROP DATABASE

 B) CREATE DATABASE

200

To retrieve data from a table, which command is used?

A) INSERT
B) DELETE
C) SELECT
D) UPDATE  

C) SELECT

300

This command deletes all rows from a table without removing the table structure. What is it? 

 A) DROP
 B) TRUNCATE
 C) DELETE
 D) REMOVE

B) TRUNCATE

400

To modify data in a table, which SQL command is used? 

A) INSERT
B) UPDATE
C) DELETE
D) SELECT

B) UPDATE

500

This command is used to remove a table and all its data from the database. What is it?

A) DROP TABLE
B) DELETE
C) TRUNCATE TABLE
D) REMOVE  

A) DROP TABLE

Basic Command 2

100

This command is used to add a new record into a table. What is it? 

A) INSERT INTO
B) UPDATE
C) SELECT
D) ADD

A) INSERT INTO

200

This command is used to modify the structure of an existing table. What is it? 

A) CREATE TABLE
B) ALTER TABLE
C) UPDATE
D) RENAME TABLE

B) ALTER TABLE

300

To remove a column from a table, which SQL command is used? 

A) DROP COLUMN
B) ALTER TABLE
C) REMOVE COLUMN
D) DELETE COLUMN

B) ALTER TABLE

400

This command is used to add a new column to an existing table. What is it? 

A) ADD COLUMN
B) ALTER TABLE
C) CREATE COLUMN
D) INSERT COLUMN

 B) ALTER TABLE

500

To change the name of an existing table, this command is used. What is it? 

A) UPDATE TABLE
B) RENAME TABLE
C) ALTER TABLE
D) CHANGE TABLE

B) RENAME TABLE