PHP

What are the main principles of creating and using composite indexes for query optimization?

What is the role of the serialization isolation level in transaction interaction management?

Do you feel comfortable when interacting formally at work?

What steps and preparatory actions should be considered when updating a software product to a new version?

What happens if a subclass calls a method that is not defined in it using self::?

Tell about your experience implementing and managing database replication systems.

What database management systems have you worked with in practice?

When is it recommended to use transactions in systems to ensure data integrity?

Have you used the iterator pattern or similar mechanisms for traversing collections in your projects?

How do the keywords self:: and static:: differ in the context of calling methods and properties in PHP?

What happens if a static method that does not exist in the class or its parent is called in a derived class?

Which versions of PHP have you used during development?

Junior — Middle

TildaMACROamoCRM

What tools and methods have you used for sequential analysis of a large data set?

Have you used auto-generation of code in your projects?

What aspects should be considered to ensure application security?

What is meant by processing and protecting special characters in strings or data?

What is the purpose of the __get__ method in Python?

What tasks are supported by transactions in a database management system?

What risks arise when multiple requests that modify the same data are executed simultaneously under two transactions?

What are the advantages of using interfaces compared to abstract classes in object-oriented programming?