Module 1: Creating Tables

What SQL keyword is used to create a new table?

• ADD TABLE

• CREATE TABLE

• INSERT INTO

• MAKE TABLE

To create a new table named "Customers" with columns "ID," "Name," and "Email," what SQL statement would you use?

• CREATE TABLE Customers (ID INT, Name VARCHAR, Email VARCHAR)

• ADD TABLE Customers (ID INT, Name VARCHAR, Email VARCHAR)

• INSERT INTO Customers (ID INT, Name VARCHAR, Email VARCHAR)

• MAKE TABLE Customers (ID INT, Name VARCHAR, Email VARCHAR)

Which SQL statement is used to insert data into a table?

• ADD DATA

• INSERT INTO

• UPDATE DATA

• ADD INTO

To view all records in a table named "Orders," which SQL statement would you use?

• SELECT * FROM Orders

• VIEW * FROM Orders

• SHOW * FROM Orders

• DISPLAY * FROM Orders

What does the following SQL statement do? SELECT Name, Age FROM Students;

• Creates a new table called "Students" with columns "Name" and "Age."

• Inserts data into the "Students" table

• Retrieves the "Name" and "Age" columns from the "Students" table

• Deletes the "Students" table