PostgreSQL вопросы и ответы для интервью
Вопрос 16. What is the purpose of the pg_hba.conf file in PostgreSQL?
The pg_hba.conf file controls client authentication, specifying which hosts are allowed to connect to the PostgreSQL server and how they can authenticate.
Вопрос 17. How can you handle concurrent access and prevent data corruption in PostgreSQL?
Concurrency control techniques include using transactions, locks, and isolation levels to ensure data consistency and prevent conflicts between multiple transactions.
Вопрос 18. What is the purpose of the pg_stat_statements module in PostgreSQL?
The pg_stat_statements module provides statistics about SQL statements executed by a server, helping identify slow queries and optimize database performance.
Вопрос 19. Explain the concept of normalization in the context of database design.
Normalization is the process of organizing data to eliminate redundancy and dependency, ensuring data integrity and reducing the likelihood of anomalies in a database.
Вопрос 20. What is the purpose of the pg_ctl utility in PostgreSQL?
The pg_ctl utility is used to start, stop, and control the PostgreSQL server, providing a convenient way to manage server processes.
Самое полезное по оценкам пользователей:
- Explain the concept of ACID properties in the context of databases.
- What is the purpose of the WHERE clause in a PostgreSQL query?
- What is a foreign key, and how does it enforce referential integrity?
- Explain the purpose of the SERIAL data type in PostgreSQL.