Which SQL statement is used to add a new record to a table?

Which SQL statement is used to add a new record to a table?

• A. UPDATE
• B. INSERT
• C. SELECT
• D. DELETE

Answer: (B)

The SQL statement used to add a new record to a table is INSERT. This command is specifically designed to add data into a specified table in a database. When using the INSERT statement, you provide the name of the table and the values for each column that you want to populate with data. For example, if you have a table called "Students" and you want to add a new student record, you would use an INSERT statement to specify the columns (like `name`, `age`, `grade`) and their corresponding values (like `'John Doe'`, `16`, `'10th Grade'`). This effectively creates a new row in the "Students" table with the provided data. The other commands serve different purposes: UPDATE modifies existing records, SELECT retrieves data from tables, and DELETE removes records from a table. Each SQL command has a distinct role, which is important to understand when managing a database.

The SQL statement used to add a new record to a table is INSERT. This command is specifically designed to add data into a specified table in a database. When using the INSERT statement, you provide the name of the table and the values for each column that you want to populate with data.

For example, if you have a table called "Students" and you want to add a new student record, you would use an INSERT statement to specify the columns (like name, age, grade) and their corresponding values (like 'John Doe', 16, '10th Grade'). This effectively creates a new row in the "Students" table with the provided data.

The other commands serve different purposes: UPDATE modifies existing records, SELECT retrieves data from tables, and DELETE removes records from a table. Each SQL command has a distinct role, which is important to understand when managing a database.