Multiple choice technology databases

Select the incorrect statement

  1. alter table table1 rename column column1 to column2

  2. alter table table1 rename to table 2

  3. alter table table1 add (c1 char(10))

  4. alter table table1 enable constraint t1_pk
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Option B is incorrect because 'table 2' contains a space, which is invalid syntax for a table name without quotes. In standard SQL, table names with spaces must be enclosed in quotes or brackets. Options A, C, and D show valid ALTER TABLE syntax in various database systems for renaming columns, adding columns, and enabling constraints respectively.

Keep practicing — related questions