Multiple choice technology mainframe

CONSTRAINTS can be specified only on Creation of a table.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Constraints can be added at table creation time using CREATE TABLE with constraints like PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, or NOT NULL. However, constraints can also be added AFTER table creation using ALTER TABLE statements, making the statement false.

AI explanation

False. Constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK) can be specified both at table creation time (in CREATE TABLE) and afterward using ALTER TABLE ... ADD CONSTRAINT. Many real-world schemas add or modify constraints well after a table already exists and contains data. So the claim that constraints can only be specified at creation is incorrect, making "False" the right answer.

Keep practicing — related questions