Which operation is used to change the values of one or more attributes in a tuple (or tuples) of some relation R?
किसी रिलेशन R के टपल (टपल्स) के एक या अधिक एट्रीब्यूट्स के मान को बदलने के लिए किस ऑपरेशन का उपयोग किया जाता है?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. Update
Explanation
UPDATE changes attribute values in existing tuples (UPDATE R SET a = v WHERE ...). DELETE removes tuples, SELECT reads them, and WHERE is only a condition clause.
UPDATE मौजूदा टपल्स में एट्रीब्यूट के मान बदलता है (UPDATE R SET a = v WHERE ...)। DELETE टपल हटाता है, SELECT पढ़ता है और WHERE केवल शर्त है।
More Database Management & SQL questions
- .......... are complete select-from-where blocks with in another SQL query.
- The select operation is used to choose a subset of tuples from a relation that satisfies a .............. .
- To get information from users you use ........... .
- This command is used to modify attribute values of one or more selected tuples :
- Degree of relationship type is the number of participating .............. .
- The query that is used to summarize the data from various tables is called as :