PHP

What is the difference between the commands 'composer install' and 'composer update', and in what situations are they used?

What experience do you have with MySQL database management systems in commercial projects?

How does PHP work?

What are anonymous functions?

What methods can be used to ensure that only one user is connected to the API at the same time?

What is PHP and SQL?

What is an aggregate?

What level of test coverage is considered normal?

Can you explain the stages of the lifecycle of a PHP application from start to finish?

What is your overall impression of the interviewer after the interview?

What steps do you take if you discover a failure in a service in the production environment?

How can you select from a database all records where the value in a certain field is less than a given threshold?

What is the role of Enterprise Service Bus (ESB) in software architecture?

What advantages and features of PHP do you particularly like?

How do you perceive the use of traits in programming?

Junior — Middle

АлгоритмикаМТС

What is a full-text index?

Have you applied the concept of traits in PHP for organizing reusable code?

Junior — Middle

amoCRM

What key innovations have been added to PHP after version 5.6?

What methods of secure token storage in the browser can be used to prevent their disclosure?

Explain the purpose of the HAVING clause in SQL and how it is used to filter grouping results.