Which of the following commands correctly defines an ENUM type called priority with values 'low', 'medium', and 'high' in PostgreSQL?

easy📝 Conceptual Q2 of 15

PostgreSQL - Advanced Features

Which of the following commands correctly defines an ENUM type called priority with values 'low', 'medium', and 'high' in PostgreSQL?

ACREATE TYPE priority ENUM ('low', 'medium', 'high');

BCREATE ENUM priority ('low', 'medium', 'high');

CCREATE TYPE priority AS ENUM ('low', 'medium', 'high');

DCREATE ENUM TYPE priority AS ('low', 'medium', 'high');

Step-by-Step Solution

Solution:

Step 1: Recall ENUM creation syntax
The correct syntax is CREATE TYPE name AS ENUM (values);
Step 2: Evaluate options
Only CREATE TYPE priority AS ENUM ('low', 'medium', 'high'); matches the correct syntax exactly.
Final Answer:
CREATE TYPE priority AS ENUM ('low', 'medium', 'high'); -> Option C
Quick Check:
Syntax must include 'CREATE TYPE' and 'AS ENUM' [OK]

Quick Trick: Use CREATE TYPE ... AS ENUM syntax [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free