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 SQL syntax shown is incorrect. Netezza's ADD COLUMN syntax does not use parentheses around the column definition. The correct syntax is: ALTER TABLE customer ADD COLUMN newcol char(10); (without parentheses wrapping the column specification).

Keep practicing — related questions