GreenRoad Technologies interview questions

explaining about the company and the job, it felt like they were looking for someone to rewrite the entire frontend. The work sounded like it was to redevelop the frontend side with the help of other people. He was expecting to be familiar with hard-core SQL because part of the job is to understand the hard queries that they have in the code base. He asked me the following questions: what are indexes? what are they good for? why don't we use indexes for everything? what is an inner / left / right join? after that there were 4 more interviews

first on call, the hiring manager asked about my experience with multithreaded multi-processing development. asked me about the object Task in cshap to explain what it is , and why there are indexes for a table in SQL database. asked me about my experience with real-time technology. moved to interview at the company site. question about creating a tasks in csharp and then how to run them was pretty hard ,not a leetcode problem.