Jagran Solutions Interview Questions and Answers

Q1. Which function is used to calculate weighted product
Ans. 
The function used to calculate weighted product is the SUMPRODUCT function.
• The SUMPRODUCT function multiplies corresponding components in the given arrays and returns the sum of those products.

• It is commonly used in financial analysis, inventory management, and supply chain optimization.

• Example: =SUMPRODUCT(A1:A3, B1:B3) will calculate the weighted product of values in cells A1 to A3 and B1 to B3.
Answered by AI
Add your answer
Q2. What can we use to summarize the data
Ans. 
Data can be summarized using various methods such as charts, graphs, tables, and statistical measures.
• Charts: Visual representation of data like bar charts, pie charts, line graphs.

• Graphs: Representing data points and relationships between them.

• Tables: Organizing data in rows and columns for easy comparison.

• Statistical measures: Calculating averages, medians, standard deviations, etc.
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated MIS executive with a strong background in data analysis and reporting.
• Experienced in managing databases and generating reports for decision-making

• Proficient in data visualization tools such as Tableau and Power BI

• Skilled in identifying trends and patterns in data to improve business processes
Answered by AI
Add your answer
Q2. Questions related to Hobbies
Add your answer

Q1. Countif, countifs, sumif, sumifs
Add your answer
Q2. Question related to vlookup
Add your answer

Q1. Marketing fundamentals
Add your answer
Q2. About oneself. Where does one see oneself a few years down the line.
Add your answer

Q1. Ambition, vision.
Add your answer

Q1. One map related question regarding sorting string according to number of occurance of characters in it.
Add your answer
Q2. Right view of tree (recursive and using level order)
Ans. 
Printing the right view of a tree using recursion and level order traversal.
• Recursively traverse the right subtree first and then the left subtree.

• For level order traversal, use a queue to store nodes at each level.

• Print the rightmost node at each level.

• Example: For tree 1-2-3-4-5, the right view is 1-2-4-5.
Answered by AI
Add your answer
Q3. Some dbms, os, system design related terminologies like (foreign key, primary key, difference between them, scaling and types of it, few question on os)
Add your answer

Q1. Basic oops concepts. with examples
Add your answer
Q2. Java specific question and to write abstract class, interface and state difference between them.
Add your answer
Q3. Solid design pattern question to implement it with given example.
Add your answer
Q4. Sql query, os related question (deadlocks, and it s resolution)
Add your answer

Q1. It was managerial round based solely on resume. asked about my internship work, how I perform in team, work which I have done in previous organisation.
Add your answer
Q2. Few fun topics and discussions
Add your answer

Q1. Hard Bounce vs Soft Bounce:What is the difference?
Ans. 
Hard bounce occurs when an email is permanently rejected, while soft bounce is a temporary issue with delivery.
• Hard bounce is a permanent failure to deliver an email, often due to invalid email addresses or domains.

• Soft bounce is a temporary issue with email delivery, such as a full inbox or server downtime.

• Hard bounces should be removed from the email list to maintain sender reputation and deliverability.

• Soft bounces ...read more
Answered by AI
View 1 more answer
Q2. Soft bounce Definition
Ans. 
Soft bounce refers to a temporary delivery issue where an email is returned to the sender due to a temporary problem with the recipient's email server.
• Soft bounce is usually caused by issues like recipient's mailbox being full, server being down, or message being too large.

• Unlike hard bounce, soft bounce emails may still be delivered successfully after the issue is resolved.

• Common examples of soft bounce include 'mailb...read more
Answered by AI
View 1 more answer

Q1. General understanding of self and work background
Add your answer

Online test with basic aptitude

Q1. Personal and Work experience background
Add your answer

Creative copy and strategy led assignments

Q1. Final round with head of team
Add your answer

Basic Communication Skills

Q1. Knowledge of the subject matter.
Add your answer

Q1. Knowledge of the subject matter and general questions
Add your answer

Q1. About yourself and work experience, knowledge, skills
Add your answer

Practical test need to done on machine

Q1. Discussion with department head
Add your answer

Q1. Salary discussion and final
Add your answer

Q1. Regarding eCommerce domain
Add your answer

Q1. Regarding eCommerce Domain
Add your answer

Q1. Regarding Salary and general attitude
Add your answer

Project Management and eCommerce domain related