Scorp Full Stack Developer interview questions

First, 15 mins phone call with hr and she sent me an interview 8 questions. It is about designing a social media app. They does not want hard coding solutions. designing database schema, sql , response/request REST apı. After received the case study I attend a technical interview. it was about case study he asked some questions about database. Most of the questions about sql. Hint: transaction, pagination, soft/hard delete in database., offset