Which of the following command can be used to modify data in an SQL Table?

A. INSERT

B. DELETE

C. UPDATE

D. SELECT

Choose the correct answer from the options given below:

  1. A, B, D only
  2. A, C, D only
  3. B, C, D only
  4. A, B, C only

Answer (Detailed Solution Below)

Option 4 : A, B, C only

Detailed Solution

Download Solution PDF

The correct answer is 4) A, B, C only.

Key Points

  • INSERT: This command is used to add new rows of data to a table. It allows you to insert new records into an existing table.
  • DELETE: This command is used to remove existing records from a table. It allows you to delete rows from a table based on specified conditions.
  • UPDATE: This command is used to modify existing records in a table. It allows you to update values in specified columns for rows that meet certain conditions.

Additional Information

  • SELECT: This command is used to retrieve data from a table. It allows you to query the database and retrieve specific data based on the conditions provided. However, it does not modify the data in the table.
  • Therefore, the correct answer includes INSERT, DELETE, and UPDATE commands, as they are all used to modify data in a table.

Hot Links: teen patti all app happy teen patti rummy teen patti