What is the INSERT command used for?

  1. To retrieve data.

  2. To insert data.

  3. To modify data.

  4. All the above


Correct Option: B

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) To retrieve data - This option is incorrect because the INSERT command is not used to retrieve data. The correct command for retrieving data is SELECT.

Option B) To insert data - This option is correct because the INSERT command is used to add new data into a table in a database. It allows you to specify the table and the values you want to insert.

Option C) To modify data - This option is incorrect. The INSERT command is not used to modify existing data. The correct command for modifying data is UPDATE.

Option D) All the above - This option is incorrect because the INSERT command is not used for retrieving or modifying data. Therefore, the correct answer is B) To insert data. This option is correct because the INSERT command is specifically used for adding new data into a table.

Find more quizzes: