Computer Science
Assertion. Both UPDATE and ALTER TABLE commands are similar.
Reason. The UPDATE command as well ALTER TABLE command make changes in the table.
DDL & DML
1 Like
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.
Answered By
3 Likes
Related Questions
Assertion. There are different commands for creating and changing table design.
Reason. The CREATE TABLE command creates the tables while ALTER TABLE command changes the design of an existing table.
Assertion. Both DELETE and DROP TABLE carry out the same thing — deletion in tables.
Reason. The DELETE command deletes the rows and DROP TABLE deletes the whole table.
What are different divisions of SQL and commands ? Give examples of commands in each division.
What is foreign key ? How do you define a foreign key in your table ?