System Analyst

Explain the order of executing an SQL query at the operator level.

What are the main HTTP methods you know?

How to consider the requirement to transfer a very large amount of data (traffic, memory)?

What is an index and how does it work on a physical level, what accelerates it?

What is database normalization and why is denormalization used?

The database queries started executing slowly. What is the sequence of actions to troubleshoot the problem?

Is it possible to use POST to retrieve data?

Are you familiar with the concept of partitions and how PARTITION BY with ORDER BY is used?

Is transitioning to the second screen form after filling out the first an include or extend in Use Case?

Tell us about your experience with artifacts: what was input and what did you prepare as output?

What is validation?

How does a Use Case differ from a User Story?

Where should validation of a required field be designed: on the front end or on the back end?

What do you mean by scalability in the context of denormalization?

How is a many-to-many relationship implemented at the physical level?