System Analyst

What is a trigger in a database?

What do you look for when job hunting, what criteria are important?

At what point is a task ready for handover to a developer?

How does PUT differ from PATCH?

What is caching?

Is it possible to perform a self-join? Why is it needed?

What motivates you at work besides financial reward?

How does REST API differ from SOAP (XML API)?

Which HTTP method is correct to use for authorization (passing login and password)?

What tasks do you find interesting and which ones not?

What can an analyst do to solve the problem of microservice overload (besides scaling, which is handled by DevOps)?

What is OpenAPI?

Is it possible to delete a record using the PUT method?

Is it possible to draw an ER diagram for a tourist routes system (tourist, route, attraction)?

How is a User Story formulated? Provide an example.