Bird
0
0

Which of the following best describes a login role in PostgreSQL?

easy📝 Conceptual Q11 of 15
PostgreSQL - Roles and Security
Which of the following best describes a login role in PostgreSQL?
AA role used only to group other roles without login capability.
BA role that can connect to the database and perform actions.
CA temporary session role that disappears after logout.
DA role that automatically grants all permissions to users.
Step-by-Step Solution
Solution:

  1. Step 1: Understand the purpose of login roles

    Login roles are created to allow users to connect to the database and perform tasks.

  2. Step 2: Differentiate from group roles

    Group roles are for organizing users and sharing permissions but cannot login themselves.

  3. Final Answer:

    A role that can connect to the database and perform actions. -> Option B

  4. Quick Check:

    Login role = can connect [OK]
Quick Trick: Login roles can connect; group roles cannot [OK]
Common Mistakes:
  • Confusing group roles with login roles
  • Thinking group roles can login
  • Assuming login roles have no permissions

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes
Indexing Strategies - Partial indexes with WHERE clause - Quiz 7medium Indexing Strategies - Analyzing index usage with pg_stat - Quiz 8hard PL/pgSQL Fundamentals - LOOP, WHILE, FOR iterations - Quiz 6medium Performance Tuning - Join algorithms (nested loop, hash, merge) - Quiz 7medium Performance Tuning - EXPLAIN output reading - Quiz 3easy Roles and Security - Why database security matters - Quiz 11easy Table Partitioning - Partition types (range, list, hash) - Quiz 14medium Table Partitioning - Sub-partitioning - Quiz 2easy Transactions and Concurrency - Serializable isolation - Quiz 5medium Transactions and Concurrency - Read committed behavior - Quiz 5medium