Basic SQL Commands Assessment 11A

What SQL command is used to create a new table?

• MODIFY TABLE

• INSERT TABLE

• ADD TABLE

• CREATE TABLE

How do you insert a new record into a table?

• Use the SQL INSERT statement.

• Use the SQL UPDATE statement.

• Use the SQL DELETE statement.

• Use the SQL SELECT statement.

Which command is used to select a database to use?

• DATABASE

• CHOOSE

• USE

• SELECT

What SQL command shows all the tables in a database?

• DISPLAY TABLES

• SHOW ALL TABLES

• LIST TABLES

• SHOW TABLES

write code for creating a database with your name