This command is used to modify attribute values of one or more selected tuples :
2023
This command is used to modify attribute values of one or more selected tuples :
- A.
Drop
- B.
Alter
- C.
Update
- D.
Modify
Attempted by 1064 students.
Show answer & explanation
Correct answer: C
The correct command to modify attribute values of one or more selected tuples in a database is the 'Update' command. Let's analyze each option: Option A: Drop / ड्रॉप – This command is used to delete a table or a column from a database. It does not modify existing data values in tuples. Hence, it is incorrect. Option B: Alter / ऑल्टर – This command is used to modify the structure of a table, such as adding or removing columns. It does not change the actual data values in existing tuples. Hence, it is incorrect. Option C: Update / अपडेट – This command is used to modify existing values in one or more tuples based on specified conditions. It directly changes attribute values, which matches the purpose described in the question. Hence, this is the correct option. Option D: Modify / मॉडिफाई – This is not a standard SQL command for modifying data. It is not used to change attribute values in tuples. Hence, it is incorrect.