How is data search performed using indexing in PostgreSQL?
Java
Explain the concept of synchronization in a multithreaded environment and why it is necessary.
Can you provide a real example of a situation where mutual resource locking occurred in a system or life?
How are tables related in the database used in your project?
How many copies of the database are used in your current system?
Have you worked with different levels of transaction isolation in databases?
Can you describe in detail the process of implementing build automation and delivery in your current project?
How can you determine occupied ports on a server using Bash?
What database replication structure is used in your project: master-slave or master-master?
Is there a separation of tables or data within the database in this project?
What prompted you to decide to look for a new job?
What clarifying questions should you ask the manager before starting to develop your own MVC architecture?
How does PostgreSQL organize data storage in a table when using an index?
How can you determine the list of open ports in the operating system using Bash commands?
How is database performance evaluated?
What protocol underlies WebSocket technology for establishing a persistent connection between client and server?
At what stage of development is transaction support implemented in this project?
How does having an index affect data search performance in PostgreSQL?
Have you dealt with using CompletableFuture for asynchronous task processing?
What are regular expressions, and what are their advantages and disadvantages to consider?