What will happen to the database record after calling PATCH (change the price to 70 thousand), and then PUT (brand not specified, color black, price not specified)?
Middle
208
System Analyst
2753
0
Please clarify how you worked with tasks: from whom they came, in what form?
Middle+
208
What types of JOINs do you know? Which JOIN produces a Cartesian product?
Middle
208
How can data reading speed be increased in a relational database?
Middle
208
Are you familiar with BPMN? How well do you know the notation, branching, and events?
Middle
208
Create a final list of questions for the customer in the form of a ready document without unnecessary symbols and emojis, based on the provided data: 1 non-resident counterparty, 16 procurement documents for the period 2018-2025, the GTD directory is empty, the country of origin China is only specified for some nomenclature (dishes), the type of contract is with a supplier, calculations are in CNY, and there are separate roles for 1-2 warehouse workers.
Middle+
208
Tell me about composite indexes, what is their feature?
Middle
208
Tell me about your last workplace, projects, and tasks you were involved in.
Middle+
208
What types of requirements exist?
Middle
208
What types of relationships have you used in databases? How is a many-to-many relationship implemented?
Middle
208
Does Kafka guarantee message read order consistency?
Middle
208
Are you preparing a specification in a knowledge base or in OpenAPI format, and what information do you describe?
Middle
207
If there are invalid numbers in the imported list, what will we do with them — send or change their status?
Senior
207
What is a two-tier and three-tier architecture? What are the pros and cons?
Senior
207
Salary expectations.
Middle+
207
Did the platform impose any requirements regarding UI and other aspects?
Middle
207
Tell me about your experience working as a systems analyst.
Middle
207
How were deviations handled when working with Kafka and REST (message did not arrive, service did not respond)?
Middle
207
What reasons guided your choice of Kafka over RabbitMQ?
Middle+
207
What is your experience with version control and requirements tracing?
Middle
207