Multiple choice technology databases

In NPS, 'ALTER TABLE customer ADD COLUMN (newcol char(10))' will add a new column to the table

  1. True

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

The statement is False because NPS doesn't support this ALTER TABLE syntax. NPS has limited ALTER TABLE capabilities and doesn't allow adding columns with this syntax. In NPS, you typically need to recreate the table to add columns. The statement looks like SQL from other databases but doesn't work in NPS.

Keep practicing — related questions