PostgreSQL Roles and Privileges Quiz

1. True or False: The PUBLIC schema privileges apply to all users automatically.

True

False

2. True or False: Role inheritance is automatically enabled for all roles.

True

False

3. Which privilege allows a role to delete rows from a table?

REMOVE

DROP

DELETE

ERASE

4. What does the BYPASSRLS attribute allow a role to bypass?

Row-level security policies

Column-level encryption

Schema restrictions

Connection limits

5. True or False: GRANT ALL PRIVILEGES grants every possible privilege on an object.

True

False

6. Which privilege grants permission to insert rows into a table?

WRITE

INSERT

ADD

APPEND

7. What command changes a role's password?

MODIFY PASSWORD

ALTER ROLE ... WITH PASSWORD

SET PASSWORD

UPDATE PASSWORD

8. True or False: A role can have a password even if LOGIN is not set.

True

False

9. Which view displays current role membership and attributes?

Pg_user

Pg_roles

Pg_members

Pg_auth

10. What does the CREATEROLE attribute allow a role to do?

Create and manage other roles

Create databases only

Create schemas only

Delete roles only

11. What command creates a new role in PostgreSQL?

CREATE ROLE

NEW ROLE

ADD ROLE

DEFINE ROLE

12. Which privilege allows a role to execute a function?

CALL

EXECUTE

RUN

INVOKE

13. What does the CREATEDB attribute allow a role to do?

Create new databases

Delete existing databases

Modify database settings only

Access all databases

14. True or False: Only superusers can create new roles in PostgreSQL.

True

False

15. Which command removes privileges from a role?

REMOVE PRIVILEGES

DENY

REVOKE

STRIP

16. What does the SUPERUSER attribute grant to a role?

Ability to create databases only

All privileges and bypass all permission checks

Ability to modify other roles only

Read-only access to all objects

17. True or False: A role can inherit privileges from other roles.

True

False

18. Which command grants privileges on a table to a role?

ASSIGN PRIVILEGES

GRANT

PERMIT

AUTHORIZE

19. What is the primary difference between a role and a user in PostgreSQL?

Users can own objects; roles cannot

A user is a role with LOGIN privilege

Roles are temporary; users are permanent

Users have more privileges than roles

20. Which attribute allows a role to log in to the database?

CONNECT

LOGIN

ACCESS

AUTHENTICATE

PostgreSQL Associate Roles and Privileges Quiz

1. True or False: The PUBLIC schema privileges apply to all users automatically.

2.

What first name or nickname would you like us to use?

2. True or False: Role inheritance is automatically enabled for all roles.

3. Which privilege allows a role to delete rows from a table?

4. What does the BYPASSRLS attribute allow a role to bypass?

5. True or False: GRANT ALL PRIVILEGES grants every possible privilege on an object.

6. Which privilege grants permission to insert rows into a table?

7. What command changes a role's password?

8. True or False: A role can have a password even if LOGIN is not set.

9. Which view displays current role membership and attributes?

10. What does the CREATEROLE attribute allow a role to do?

11. What command creates a new role in PostgreSQL?

12. Which privilege allows a role to execute a function?

13. What does the CREATEDB attribute allow a role to do?

14. True or False: Only superusers can create new roles in PostgreSQL.

15. Which command removes privileges from a role?

16. What does the SUPERUSER attribute grant to a role?

17. True or False: A role can inherit privileges from other roles.

18. Which command grants privileges on a table to a role?

19. What is the primary difference between a role and a user in PostgreSQL?

20. Which attribute allows a role to log in to the database?