Multiple choice technology databases

It is possible to create a constraints on the existing tables by creating new column

  1. True

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

You can add constraints to existing tables using ALTER TABLE, but you add constraints to existing columns, not by creating new columns. The statement claims constraints are added 'by creating new column' which is not correct - constraints are added to columns that already exist. You can also add new columns WITH constraints, but the constraint itself is not created by adding a column. The statement is false.

Keep practicing — related questions