This quiz will test your understanding of creating and managing databases and tables in MySQL. You will explore fundamental concepts such as using the CREATE DATABASE and CREATE TABLE statements, defining primary keys, handling NULL values, working with AUTO_INCREMENT, and specifying default values. Additionally, you will learn about storage engines, how to modify and delete tables, and the impact of different table constraints.
1.
What must a column have to be defined as a primary key?
2.
Which keyword prevents a column from storing NULL values?
3.
What happens if you try to insert a NULL value into a NOT NULL column?
4.
Which of the following can also be used to create a new database?
5.
What happens if you try to create a database that already exists?
6.
Which command displays a list of all databases on the server?
7.
What is the correct SQL command to create a table?
8.
Which statement is used to select a database for use?
9.
How can you avoid an error when creating a database that might already exist?
10.
How do you retrieve the structure of a table (select all that apply)?
11.
Which SQL statement is used to create a new database?
12.
What is the function of the MEMORY storage engine?
13.
Which command is used to check the default storage engine in MySQL?
14.
Which statement is used to delete an entire database?
15.
Which MySQL storage engine is transaction-safe?
16.
How do you remove all data from a table without deleting the table itself?
17.
Which of the following is NOT a valid MySQL storage engine?
18.
Which statement is used to delete a table from a database?
19.
Which SQL statement allows you to change the structure of an existing table?
20.
Which SQL keyword is used to assign a default value to a column?
