Question

SQL command used to modify attribute values of one or more selected type is:
1. MODIFY
2. UPDATE
3. INSERT
4. ALTER

Answer 1

Correct Answer - Option 2 : UPDATE

Concepts

SQL command used to modify attribute values of one or more selected types is UPDATE.

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

Syntax:

The UPDATE statement is used to modify the existing records in a table.

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Therefore Option 2 is correct

ALTER TABLE Modify Column command. For Oracle and MySQL, the SQL syntax for ALTER TABLE Modify Column is,

ALTER TABLE "table_name" MODIFY "column_name" "New Data Type";

The INSERT INTO statement is used to insert new records in a table.

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);