They might ask a person who has no experience in software development to conduct a technical interview.

Be sure to check the LinkedIn profile of the interviewer before the interview. If the interviewer has never performed the job they are interviewing for (software development, in this case), it's a red flag.

Such a person will view software development in black and white, rather than as a series of trade-offs. The reality is that software development involves trade-offs; there is no perfect solution for every scenario.

Unfortunately, because my interviewer had no software development experience, they were very picky about syntax. For instance, the feedback mentioned that the candidate discussed cascade delete but didn't know the syntax.

Another point they mentioned was, "Candidate proposed to use JSON fields to store product attributes." During the interview, I mentioned how things could be stored in a noSQL MongoDB-like database, but it seems they interpreted this within the context of SQL.

The baseline is that such interviewers will have a fixed solution in mind. If you meet all those specific points, it's a 'yes'; otherwise, it's a 'no'.

To design a database schema.