You want to add a new value 'archived' to an existing ENUM type status with values ('new', 'in_progress', 'done'). Which statement correctly adds 'archived' after 'done'?

hard📝 Application Q15 of 15

PostgreSQL - Advanced Features

You want to add a new value 'archived' to an existing ENUM type status with values ('new', 'in_progress', 'done'). Which statement correctly adds 'archived' after 'done'?

AALTER TYPE status ADD VALUE 'archived' BEFORE 'in_progress';

BALTER TYPE status ADD VALUE 'archived' AFTER 'done';

CALTER TYPE status ADD VALUE 'archived' BEFORE 'done';

DALTER TYPE status MODIFY VALUE 'archived' AFTER 'done';

Step-by-Step Solution

Solution:

Step 1: Recall how to add ENUM values
PostgreSQL uses ALTER TYPE ... ADD VALUE 'new_value' [BEFORE|AFTER existing_value] syntax.
Step 2: Identify correct position
To add 'archived' after 'done', use AFTER 'done'.
Step 3: Check options
ALTER TYPE status ADD VALUE 'archived' AFTER 'done'; matches correct syntax and position. Others use BEFORE (wrong position) or invalid keywords.
Final Answer:
ALTER TYPE status ADD VALUE 'archived' AFTER 'done'; -> Option B
Quick Check:
ALTER TYPE ADD VALUE ... AFTER ... [OK]

Quick Trick: Use ALTER TYPE ADD VALUE 'val' AFTER 'existing' to position [OK]

Common Mistakes:

Using MODIFY instead of ADD VALUE
Placing new value BEFORE wrong existing value
Using wrong position like BEFORE 'done'

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

You want to add a new value 'archived' to an existing ENUM type status with values ('new', 'in_progress', 'done'). Which statement correctly adds 'archived' after 'done'?

Step 1: Recall how to add ENUM values

Step 2: Identify correct position

Step 3: Check options

Final Answer:

Quick Check:

Want More Practice?