Project A Data Engineer/Data Scientist interview questions

I met the team at a conference and expressed my interest in working in the company. I was well received by their data engineering chief officer. He told me to send my application and then we will have a Skype call about software craftsmanship. I sent my application and got an answer in two days to schedule the interview. The interview questions were mostly about database, queries, database administration. One was about basic algorithms knowledge (find the second maximum in an array). I asked him why do they choose "Data engineer/data scientist" as a title, he explained to me that they need a person who knows how to do data engineering stuff because there are no database system administrators in the company and the data scientist has to ensure both data engineering stuff and data science stuff. I did well in the basic algorithm question but in the database knowledge, I was missing most of the points because I don't have a big experience on. So, the interviewer told me that I would not fit the position. I appreciated his fast feedback and honesty, also he gave me advice on how to improve my database knowledge as I asked him. After few days, I received an official email of rejection.