Questions sur PostgreSQL

PostgreSQL Questions and Answers - Multiple Choice

• Creating a Superuser Role: The command to create a superuser role in PostgreSQL is CREATE ROLE role_name SUPERUSER LOGIN PASSWORD password;.

• DBA Role and Data Security: A DBA's role in data security involves evaluating security measures, but not necessarily creating superuser roles or granting all table privileges.

• Data Refreshing Process (Non-Production Environment): The process to refresh the non-production environment usually involves creating clones, identifying sensitive data, and applying masking rules. This is not necessarily followed by creating a superuser.

• Granting Privileges on All Tables: The command to grant all privileges on all tables in a schema to a user is GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA 'public' TO username;

• External Authentication: PostgreSQL uses PAM (Pluggable Authentication Modules) for external authentication in addition to other security protocols.

PostgreSQL Advanced Questions - True or False

• Creating Another Superuser: A superuser in PostgreSQL can create another superuser role. (True)

• Database Authentication: Database authentication is similar to using a password to access a phone. (True)

• DBA and Security Evaluation: The DBA is responsible for assessing security measures. (False)

PostgreSQL Advanced Questions - Multiple Choice

• Role Creation Keyword WITH: The WITH keyword is not mandatory when creating a role in PostgreSQL. (False)

• LDAP Authentication: The LDAP protocol can be used as external authentication method in PostgreSQL. (True)

• Revoking Privileges: To revoke all privileges from a user on a table, use REVOKE ALL on that user for that table. (True)

• Anonymisation Process and Source Data: The source database in an anonymization process, is not where the result of the anonymization process is located. (False)

• DBA Role and Access Permissions: The DBA in PostgreSQL typically manages service configurations and user permissions. (True)