Multiple choice technology databases

Which of the following objects could not be modified using ALTER statement

  1. Tablespace

  2. Sequence

  3. Views

  4. Index

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Views cannot be modified using ALTER. To change a view definition, you must DROP and recreate it. In contrast, ALTER TABLESPACE can change attributes like logging, ALTER SEQUENCE can restart or change increment, and ALTER INDEX can modify certain index properties.