MySQL Easy-Advanced Mix

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

• MAKE DATABASE

• NEW DATABASE

• CREATE DATABASE

• BUILD DATABASE

What command is used to display all available databases?

• SHOW DATABASES

• LIST DATABASE

• DISPLAY DATABASE

• SELECT DATABASE

Which SQL statement is used to add new records to a table?

• INSERT NEW

• INSERT INTO

• ADD RECORD

• CREATE ROW

Which clause is used to filter records in a SELECT statement?

• ORDER BY

• WHERE

• GROUP BY

• HAVING

What command deletes all rows from a table but not the table itself?

• DROP TABLE

• REMOVE TABLE

• DELETE TABLE

• TRUNCATE TABLE

Which function returns the total number of rows in a result set?

• SUM()

• TOTAL()

• COUNT()

• NUMBER()

What type of JOIN returns all records that have matching values in both tables?

• FULL JOIN

• LEFT JOIN

• RIGHT JOIN

• INNER JOIN

Which keyword sorts the result set?

• SORT

• ORDER BY

• GROUP BY

• ASCEND

What constraint uniquely identifies each record in a table?

• FOREIGN KEY

• PRIMARY KEY

• UNIQUE KEY

• DEFAULT KEY

Which SQL command is used to remove a table completely from the database?

• DELETE TABLE

• ERASE TABLE

• DROP TABLE

• REMOVE TABLE