Question

Which SQL commands will we use if we need to add a new table to a database and then add values to that table?

1) CREATE TABLE and INSERT INTO
2) ALTER TABLE and UPDATE
3) SELECT and DELETE
4) DROP TABLE and TRUNCATE

Answer 1

To add a new table to a database and then add values to that table, use the CREATE TABLE command followed by the INSERT INTO command. CREATE TABLE is used for creating a new table, and INSERT INTO is used to add new rows of data to that table.

Step-by-step explanation:

If we need to add a new table to a database and then add values to that table, we would use the CREATE TABLE command followed by the INSERT INTO command. The CREATE TABLE command is used to create a new table within the database, where you define the table name, and columns along with their data types. After creating the table, you then use the INSERT INTO command to add values to the table; this is where you specify the columns for which you'll insert the data and the corresponding values for each column.

To clarify:

1. CREATE TABLE: This command is used to create a new table in the database.
2. INSERT INTO: This command adds new rows of data to an existing table.

The other commands presented have different functions:

• ALTER TABLE is used to modify an existing table structure, such as adding a new column.
• UPDATE modifies the existing data within the table.
• SELECT is used to query data from the database.
• DELETE removes data from a table.
• DROP TABLE completely removes a table and its data from the database.
• TRUNCATE removes all rows from a table without deleting the table itself.