Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 6 of 79

Table Creation and Data Manipulation Commands — Question 6

Back to all questions
6
Question

Question 6

Assertion. Both UPDATE and ALTER TABLE commands are similar.

Reason. The UPDATE command as well ALTER TABLE command make changes in the table.

Answer

(e)

Both Assertion and Reason are false.

Explanation
The UPDATE command specifies the rows to be changed using the WHERE clause and the new data using the SET keyword. On the other hand, the ALTER TABLE command is used to change the definitions of existing tables. It can add columns, integrity constraints, and redefine columns. While both commands involve making changes, they operate on different aspects of the table - UPDATE command modifies data, while ALTER TABLE command modifies the table structure.