(L1 Round)–
-Give me a brief introduction about you and your projects.
-What was your exact role in projects and what functionality have you developed?
SQL Based Questions –
-Consider 2 tables, employee and department, where each employee is mapped to a department. What is the foreign key, and in which table is it maintained?
-Following the above query, count the number of employees in each department and print the department name and the count.
-If the same employee is mapped to two departments, what will be the query? What will be the foreign key and primary key? How do you maintain the data, and what will be the approach?
-Consider there are no departments for an employee; will you get the same output?
-If any employee value is “NULL” with no department, how many records will you get?
