Which of the following is the correct SQL command to enable the uuid-ossp extension in PostgreSQL?

easy📝 Syntax Q12 of 15

PostgreSQL - Advanced Features

Which of the following is the correct SQL command to enable the uuid-ossp extension in PostgreSQL?

ACREATE EXTENSION uuid-ossp;

BENABLE EXTENSION uuid-ossp;

CINSTALL EXTENSION uuid-ossp;

DADD EXTENSION uuid-ossp;

Step-by-Step Solution

Solution:

Step 1: Recall the syntax to enable extensions
In PostgreSQL, extensions are enabled using the command CREATE EXTENSION extension_name;.
Step 2: Verify the correct command for uuid-ossp
The correct command is CREATE EXTENSION uuid-ossp;. Other options are invalid SQL syntax.
Final Answer:
CREATE EXTENSION uuid-ossp; -> Option A
Quick Check:
Enable extension = CREATE EXTENSION [OK]

Quick Trick: Use CREATE EXTENSION to enable PostgreSQL extensions [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