Should a PHP middle programmer be good at databases?

Question

PHP

At an interview, for example, they might ask the following question: "What are the types of indexes?".
Would a simple enumeration of index types (Hash, B-Tree...) be considered an acceptable answer?
Or the middle should know the details and the answer of the format will be acceptable: there are such indexes (we enumerate), for example, hash indexes based on the hash of the table, that the hash of the tables has a collision problem that is resolved by the method of chains or open addressing, and a good hash -function must have such properties as determinism, uniformity, in general, in such a spirit ...

Answer 1

Would a simple enumeration of index types (Hash, B-Tree...) be considered an acceptable answer?

No. For good, you should also know which situations are better for which and how they are roughly arranged.
But this is in principle not a mandatory thing - if you say something like

I didn’t have to deal with tasks where you need to understand the indexes directly, but if such a situation arises, then I will look at the documentation and decide.

That will also be a good answer, if you can really determine which task is best applied to.

Answer 2

It largely depends on the specifics of the project, but in short - must understand databases. Specifically about indexes - I would say that this may not be necessary.

Answer 3

I was once asked about how to set up replication and what binary log is (specifically about MySQL). I don't know if that's called "getting it right" or not?