PHP

How is the MVC structure organized in application architecture?

Could you explain the purpose and working principle of the UNION operator in PostgreSQL?

Can you explain what the HTTP PATCH method means in the context of REST API?

What major PHP projects have you worked on?

Have you used ENUM types in PostgreSQL for storing a limited set of values?

Have you been involved in improving the performance and efficiency of SQL queries?

Junior — Middle

amoCRM

Explain the differences between Active Record and Data Mapper approaches when working with databases.

What attracted you to choose Laravel over Symfony when developing a project?

Explain the differences between GET and POST methods in the context of HTTP protocol and web applications.

What motivated you to choose Python as the language to learn?

Can you explain the Dependency Inversion Principle and its importance in software development?

Could you list the main normal forms used in database design?

What happens to an object after it is passed to a function and its state is subsequently changed inside the function?

Do you write queries that adhere to principles of cleanliness and readability when working with databases?

How did you handle conflicts in the work environment?

How do you recover your strength after a workday?

What methods do you use to find and fix bugs in your code?

What features or new capabilities have you noticed when using job search websites?

What is the purpose and application of Traits in programming?

If an object is passed to a function, will its state change be visible outside of it?