Junior Associate Consultant – Full Stack Developer

Explain the difference between:

• Node.js (backend runtime)
• React.js (frontend library)

Also, when do we use Bootstrap in a web project?

• You are given two tables — Employees(emp_id, emp_name, dept_id) and Departments(dept_id, dept_name).
• Write an SQL query to fetch all employee names along with their department names using a JOIN.

Given a string, write a program to count the number of vowels, consonants, and spaces in that string.

EXAMPLE :

Input: ‘N’= 25, ‘s’ =”Take u forward is Awesome”
Output: 10 11 4

Given a table Employees(id, name, salary, department), write an SQL query to fetch the highest salary in each department.

You are asked to explain your project architecture.
Describe:

• How data flows from frontend → backend → database
• How you implemented authentication
• Which technologies (Node.js, Express, React, SQL) were used and why