How to select data from a table, including records with zero values in certain fields?
PHP
Tell us about yourself from your last job — [organization]
What consequences can arise from infinite recursion in a program?
How do you find out about innovations and updates in PHP?
Can you explain the working principle of the Observer pattern and in which scenarios it is used?
How to choose the most suitable data structure for fast operations on unique column values?
Have there been situations where disagreements with management arose during project or task implementation?
What should be given special attention when performing an interactive rebase in the Git version control system?
Can you share your experience of independently completing projects?
What type of index should be used when you need to efficiently search for records across multiple fields in a table?
Can the time() function in PHP be considered a pure function that does not affect external state and does not use global variables?
What types of indexes can be created in PostgreSQL database?
Are you interested in working with user interfaces?
Explain what the EXPLAIN command does in SQL queries.
Do you prefer working on large-scale systems or small tasks?
What professional goals and plans for further development do you set for yourself?
What well-known design patterns do you apply when developing system architecture?
Do you have questions about implemented technical solutions or project architecture?
What types of methods are allowed when declared inside an abstract class?
Can you explain what is meant by the concept of variable lifting in programming?