SQL command used to modify attribute values of one or more selected type is:

This question was previously asked in
HTET PGT Official Computer Science Paper - 2019
View all HTET Papers >
  1. MODIFY
  2. UPDATE
  3. INSERT
  4. ALTER

Answer (Detailed Solution Below)

Option 2 : UPDATE
Free
HTET PGT Official Computer Science Paper - 2019
4.4 K Users
60 Questions 60 Marks 60 Mins

Detailed Solution

Download Solution PDF

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

Additional Information

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, ...);

Latest HTET Updates

Last updated on Jun 6, 2025

-> The HTET TGT Applciation Portal will reopen on 1st June 2025 and close on 5th June 2025.

-> HTET Exam Date is out. HTET TGT Exam will be conducted on 26th and 27th July 2025

-> Candidates with a bachelor's degree and B.Ed. or equivalent qualification can apply for this recruitment.

-> The validity duration of certificates pertaining to passing Haryana TET has been extended for a lifetime.

-> Enhance your exam preparation with the HTET Previous Year Papers.

Get Free Access Now
Hot Links: teen patti live teen patti rummy teen patti circle teen patti casino teen patti 50 bonus