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

Table Creation and Data Manipulation Commands — Question 4

Back to all questions
4
Question

Question 4

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.

Answer

(a)

Both Assertion and Reason are true and Reason is the correct explanation of Assertion.

Explanation
The CREATE TABLE command is used to create tables in a database, specifying the table's structure, including column names, data types, and constraints. Conversely, the ALTER TABLE command is used to modify the structure of an existing table, such as adding, removing, or modifying columns, constraints, or indexes.