Multiple choice

Which of the following options is not true about modifying table columns?

  1. You can drop a column at any time.

  2. You can add a column at any time as long as it is a NULL column.

  3. You can increase the number of characters in character columns or the number of digits in numeric columns.

  4. You cannot increase or decrease the number of decimal places.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle does allow modifying decimal places in NUMBER columns under certain conditions: you can always increase decimal places, and you can decrease them if existing data fits without rounding errors. The statement claiming you cannot increase OR decrease decimal places is therefore false, making D the correct answer to the 'not true' question.

Keep practicing — related questions