Denodo Data Engineer Associate interview questions

I applied through smartrequiters website ELIGIBILITY CRITERIA: FRESHERS with no baglogs. ROLE: ASSOCIATE DATA ENGINEER. 1) Online exam conducted via mettl Online exam consist of 5 sections A) Aptitude (17 questions) B) English (15 questions) C) Logical Reasoning(12 questions) D) SQL(15 questions) E) Java(15 questions) All are mcq type questions. 2) Group discussion round Virtually conducted via Gotomeeting due to Covid -19 lockdown It consists of 8 participants and 3 requiters Topic given is SOCIAL MEDIA BOON OR CURSE 3) Presentation Round Virtually conducted via Gotomeeting Presentation consist of ABOUT MYSELF, ABOUT COMPANY, COLLEGE PROJECT. Questions from my college project and technical questions Eg:SQL, JAVA., OOPS Concepts, OS. SQL: 1) Write a query for number of employees in HR department in employees table SELECT COUNT(*) FROM EMPLOYEES WHERE DEPARTMENT='HR'; 2) Write a query for display Employees details whose name starts with "E" SELECT * FROM EMPLOYEES WHERE NAME LIKE 'E℅'; 4) HR Round But I am not selected for HR round. So I learnt many things from this interview and I will correct my mistakes and try my best for the next interview. NEVER GIVE UP.