Basic SQL Commands Assessment 10 A

What SQL command is used to create a new table?

• CREATE TABLE

• INSERT TABLE

• ADD TABLE

• MODIFY TABLE

How do you insert a new record into a table?

• Use the SQL INSERT statement.

• Use the SQL SELECT statement.

• Use the SQL UPDATE statement.

• Use the SQL DELETE statement.

Which command is used to select a database to use?

• DATABASE

• USE

• CHOOSE

• SELECT

What SQL command shows all the tables in a database?

• DISPLAY TABLES;

• SHOW ALL TABLES;

• SHOW TABLES;

• LIST TABLES;

How do you retrieve data from a table using specific criteria?

• Use a SQL SELECT statement with a WHERE clause to filter data.

• Access data through a JSON file instead of a database.

• Use a SQL UPDATE statement to modify data.

• Retrieve data using a DELETE statement.