Which of the following is the correct syntax to create a role named 'developer' with login and password 'devpass'?

easy📝 Syntax Q3 of 15

PostgreSQL - Roles and Security

ACREATE ROLE developer LOGIN PASSWORD 'devpass';

BCREATE USER developer WITH PASSWORD 'devpass';

CCREATE ROLE developer WITH LOGIN PASSWORD 'devpass';

DCREATE ROLE developer PASSWORD 'devpass' LOGIN;

Step-by-Step Solution

Solution:

Step 1: Recall correct syntax for role creation with login and password
The correct syntax uses WITH LOGIN PASSWORD 'password' after role name.
Step 2: Compare options
CREATE ROLE developer WITH LOGIN PASSWORD 'devpass'; matches the correct syntax: CREATE ROLE developer WITH LOGIN PASSWORD 'devpass';
Final Answer:
CREATE ROLE developer WITH LOGIN PASSWORD 'devpass'; -> Option C
Quick Check:
Role with login and password = WITH LOGIN PASSWORD [OK]

Quick Trick: Use WITH LOGIN PASSWORD for role creation with password [OK]

Common Mistakes:

Master "Roles and Security" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free