WiJungle Interview Questions and Answers

The task was a Codility type

Q1. Questions were mostly related to Django Rest Framework and internal working of it, apart from that there were questions related to Django ORM.
Add your answer
Q2. Given an API request how would to resolve the space issue that is happening with GET
Ans. 
To resolve space issue with GET API request, consider pagination, compression, caching, and optimizing query parameters.
• Implement pagination to limit the number of results returned in each request.

• Use compression techniques like Gzip to reduce the size of the response data.

• Implement caching mechanisms to store frequently accessed data and reduce the number of requests.

• Optimize query parameters to only request necessary
Answered by AI
View 1 more answer

Q1. Complete resume based questions
Add your answer
Q2. You must me thorough of what you have mentioned in your resume.
Add your answer

Q1. They asked about projects
Add your answer
Q2. They asked about projects and data analytics
Add your answer

Q1. Tell me about yourself and your role & experience in the field.
Ans. 
I have over 5 years of experience in retail management, leading teams to achieve sales targets and providing excellent customer service.
• Managed a team of 15 sales associates at XYZ Retail Store

• Increased sales by 20% through implementing new sales strategies

• Trained new employees on product knowledge and customer service

• Handled customer complaints and resolved issues effectively
Answered by AI
Add your answer

Q1. I was provided with three tables: 1st table had city wise sales, 2nd table had province_id and name, 3rd table had city_id, city_name, and province_id 1. Get the highest sales value, city, province. Do th...read more
Add your answer
Q2. Can aggregate functions be used with HAVING clause? With WHERE clause? What is the difference between WHERE and HAVING clause? Can HAVING be used without GROUP BY?
Ans. 
Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.
• Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.

• Aggregate functions can also be used with WHERE clause to filter rows before grouping.

• WHERE clause filters rows before grouping, while HAVING clause filters groups aft...read more
Answered by AI
View 1 more answer
Q3. What is the order of execution of a SQL Query?
Ans. 
The order of execution of a SQL query is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• FROM: Specifies the tables involved in the query

• WHERE: Filters the rows based on specified conditions

• GROUP BY: Groups the rows that have the same values into summary rows

• HAVING: Filters the groups based on specified conditions

• SELECT: Selects the columns to be displayed in the result set

• ORDER BY: Sorts the result set based on speci
Answered by AI
View 1 more answer
Q4. What are User Defined Functions? Stored Procedures? Triggers?
Ans. 
User Defined Functions, Stored Procedures, and Triggers are database objects used to perform specific tasks in database management systems.
• User Defined Functions are custom functions created by users to perform specific calculations or operations in a database.

• Stored Procedures are precompiled SQL statements that can be executed by calling the procedure name.

• Triggers are special types of stored procedures that are auto...read more
Answered by AI
Add your answer

Q1. This was a managerial round
Add your answer