Which SQL command correctly creates a group role named managers without login capability?

easy📝 Syntax Q12 of 15

PostgreSQL - Roles and Security

Which SQL command correctly creates a group role named managers without login capability?

ACREATE ROLE managers NOLOGIN;

BCREATE ROLE managers LOGIN;

CCREATE USER managers;

DCREATE ROLE managers WITH LOGIN;

Step-by-Step Solution

Solution:

Step 1: Recall syntax for creating roles without login
To create a group role, use CREATE ROLE with NOLOGIN option.
Step 2: Analyze options
CREATE ROLE managers NOLOGIN; uses NOLOGIN correctly; options B and D enable login; CREATE USER managers; creates a login user.
Final Answer:
CREATE ROLE managers NOLOGIN; -> Option A
Quick Check:
Group role = NOLOGIN [OK]

Quick Trick: Use NOLOGIN to create group roles [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