Bird
0
0

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:
  1. Step 1: Recall syntax for creating roles without login

    To create a group role, use CREATE ROLE with NOLOGIN option.
  2. Step 2: Analyze options

    CREATE ROLE managers NOLOGIN; uses NOLOGIN correctly; options B and D enable login; CREATE USER managers; creates a login user.
  3. Final Answer:

    CREATE ROLE managers NOLOGIN; -> Option A
  4. Quick Check:

    Group role = NOLOGIN [OK]
Quick Trick: Use NOLOGIN to create group roles [OK]
Common Mistakes:
  • Using LOGIN when creating group roles
  • Using CREATE USER instead of CREATE ROLE
  • Omitting NOLOGIN for group roles

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes