Techchahiye Interview Questions and Answers

Q1. SQL question ( window functions) dense_rank
Add your answer
Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
Add your answer
Q3. Some question on spark optimisations
Add your answer

Q1. How to calculate requirement of Banana is a city like Mumbai
Ans. 
The requirement of bananas in a city like Mumbai can be calculated based on population, consumption habits, and availability.
• Calculate the population of Mumbai

• Estimate the average consumption of bananas per person

• Consider factors like tourism and events that may increase demand

• Take into account the availability of bananas from local markets and imports
Answered by AI
Add your answer
Q2. How to know , difference between a good or bad retailer
Ans. 
A good retailer focuses on customer satisfaction, product quality, and efficient operations.
• Good retailers prioritize customer satisfaction by providing excellent customer service and addressing customer needs.

• Good retailers offer high-quality products that meet customer expectations.

• Good retailers have efficient operations, including inventory management, supply chain logistics, and streamlined processes.

• Bad retailers...read more
Answered by AI
Add your answer
Q3. Simple SQL questions
Add your answer

Q1. What is the Total Experience as the All Lines
Add your answer

Group Discussion as the ABM ,GM , Founder and Co Fouder

Q1. What is the Experience total years
Add your answer
Q2. Where are you Working Location
Add your answer

Q1. Which is the Reporting Manager
Ans. 
The Reporting Manager is the individual to whom the Business Development Manager will report to.
• The Reporting Manager is typically a higher-level manager within the organization

• They are responsible for overseeing the work and performance of the Business Development Manager

• The Reporting Manager provides guidance, feedback, and support to the Business Development Manager

• Examples of Reporting Managers could include the Di...read more
Answered by AI
Add your answer
Q2. What is the Experience in All sector
Add your answer

Quantiative Aptitude

Q1. Questions related to basic DSA, Searching, sorting, SQL Queries based on aggregate functions, Basic puzzle (GFG)
Add your answer

Q1. Resume based, Discussion about projects mentioned on the resume.
Add your answer

Q1. Strength, Weakness,
Add your answer

Q1. I was questioned about the 7 QC tools
Add your answer
Q2. They asked me about my roles and responsibility
Add your answer

Q1. Basic information about trading nd comodity
Add your answer
Q2. Comodity against and also moisture nd farmer Producer Company regards
Add your answer

It's very easy and logical thinking is most important factor

It's medium level question and write the efficient code

Q1. What is Encapsulation
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for data hiding, which prevents outside code from directly accessing an object's internal data.

• Encapsulation also promotes code reusability and modularity by grouping related data and methods together.

• ...read more
Answered by AI
Add your answer
Q2. What is method overload
Ans. 
Method overload is when multiple methods in a class have the same name but different parameters.
• Method overload allows multiple methods in a class to have the same name but different parameters.

• The compiler determines which method to call based on the number and type of parameters passed.

• Example: void print(int num) and void print(String text) are overloaded methods with the same name 'print'.
Answered by AI
Add your answer

Q1. Introducing yourself
Add your answer
Q2. What are strength
Ans. 
Strengths are qualities or attributes that make an individual or team successful in achieving goals.
• Physical strength - ability to lift heavy objects or perform physically demanding tasks

• Emotional strength - resilience in facing challenges and managing stress

• Analytical strength - ability to solve complex problems and think critically

• Interpersonal strength - effective communication and teamwork skills

• Adaptability - abil...read more
Answered by AI
Add your answer

Q1. Pointer and types of pointer
Ans. 
Pointers are variables that store memory addresses of other variables. They are used to access and manipulate data indirectly.
• Pointer is a variable that stores memory address

• Types of pointers include null pointer, void pointer, function pointer

• Example: int *ptr; // pointer to an integer variable
Answered by AI
Add your answer
Q2. Handover and types of ho
Ans. 
Handover is the process of transferring control of a system from one entity to another. Types include hard handover and soft handover.
• Handover is the process of transferring control of a system from one entity to another.

• Types of handover include hard handover and soft handover.

• Hard handover involves a complete break before the new connection is established.

• Soft handover allows for overlapping connections during the tr
Answered by AI
Add your answer

Q1. More about myself.
Add your answer

Q1. Talk on something which is not given on my CV.
Add your answer

Q1. What is Pepper content?
Ans. 
Pepper content is a digital marketing agency that specializes in creating engaging content for brands to connect with their target audience.
• Pepper content provides services such as content creation, social media management, and influencer marketing.

• They work with brands to develop content strategies that resonate with their target market.

• Pepper content helps brands increase their online presence and engagement through ...read more
Answered by AI
Add your answer
Q2. What does Pepper Content do?
Ans. 
Pepper Content is a content creation platform that connects businesses with freelance writers, designers, and creators.
• Pepper Content helps businesses create high-quality content for their marketing needs.

• They offer services such as blog writing, social media management, video production, and graphic design.

• Pepper Content has a network of skilled freelancers who work on projects for clients.

• The platform provides a seam...read more
Answered by AI
Add your answer