Hic Abf Special Foods Interview Questions and Answers

Q1. SQL question to return the shortest duration of flight to travel from NY to HND
Ans. 
Use SQL query to find shortest flight duration from NY to HND
• Use SQL query with MIN function to find shortest duration

• Filter flights from NY to HND using WHERE clause

• Calculate duration by subtracting arrival time from departure time
Answered by AI
Add your answer
Q2. Pyspark question to read data from a CSV file
Add your answer
Q3. There was no question 3
Add your answer

Q1. Mostly discussions on Projects at my current company, Design choices and spark related concepts used for optimisations.
Add your answer
Q2. SQL question to test syntax knowledge
Add your answer
Q3. HRM typical questions like: Why join Grab?
Add your answer

Test contains 26 questions for me 13 are java based 13 are c++ based

Q1. Indexing in dbms
Ans. 
Indexing in DBMS is a technique to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
• Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.

• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Examples of indexing techniques include B-tree, hash, and bitmap indexes.

• Indexing can...read more
Answered by AI
Add your answer
Q2. Find whether two strings are or not anagrams
Ans. 
Check if two strings are anagrams by comparing the sorted characters in each string.
• Sort the characters in both strings and compare if they are equal.

• Ignore spaces and punctuation when comparing the strings.

• Example: 'listen' and 'silent' are anagrams.

• Example: 'hello' and 'world' are not anagrams.
Answered by AI
View 1 more answer

Q1. Inorder traversal without recursion
Ans. 
Use a stack to simulate the recursive inorder traversal process
• Create an empty stack to store nodes

• Start with the root node and push it onto the stack

• While the stack is not empty, keep traversing left and pushing nodes onto the stack

• Once you reach a leaf node, pop it from the stack, print its value, and move to its right child

• Repeat the process until all nodes have been visited
Answered by AI
Add your answer
Q2. How to make a class final
Ans. 
To make a class final, use the 'final' keyword in the class declaration.
• Use the 'final' keyword before the 'class' keyword in the class declaration

• A final class cannot be subclassed or extended

• Final classes are often used for utility classes or classes that should not be modified
Answered by AI
Add your answer

Q1. Past experience and questions around that
Add your answer
Q2. High level software design for eCommerce system
Add your answer

Q1. Why do you think, you are fit for this role?
Ans. 
I have a proven track record of successfully managing key accounts and exceeding sales targets.
• Strong communication and negotiation skills

• Ability to build and maintain relationships with key clients

• Experience in developing strategic account plans

• Proven track record of meeting and exceeding sales targets

• Familiarity with CRM systems and sales analytics
Answered by AI
Add your answer
Q2. Your past achievements
Ans. 
Consistently exceeded sales targets by 20% for the past 3 years through strategic account management and relationship building.
• Exceeded sales targets by 20% for the past 3 years

• Implemented strategic account management techniques

• Built strong relationships with key accounts

• Received recognition for top performance in sales
Answered by AI
Add your answer

Q1. Intro about yourself
Ans. 
Experienced Key Account Manager with a proven track record of exceeding sales targets and building strong client relationships.
• Over 5 years of experience in key account management

• Successfully increased sales by 20% in the last quarter through strategic account planning

• Strong communication and negotiation skills

• Ability to analyze market trends and identify growth opportunities

• Managed key accounts such as Company A and C
Answered by AI
Add your answer
Q2. Past incident where you hustled and succeded
Ans. 
I hustled to secure a key account by going above and beyond to meet their needs and exceed expectations.
• Identified key pain points of the client and proposed tailored solutions

• Worked overtime to prepare a comprehensive presentation showcasing our products/services

• Followed up diligently and addressed any concerns promptly

• Negotiated terms and pricing to ensure a win-win situation for both parties
Answered by AI
Add your answer

Q1. What company does?
Add your answer
Q2. Are you aware of your roles and responsibilities?
Ans. 
Yes, I am aware of my roles and responsibilities as a Key Account Manager.
• I am responsible for managing and growing relationships with key clients.

• I need to understand the needs and goals of each key account.

• I must develop strategies to meet the needs of key clients and achieve sales targets.

• I am accountable for the overall success of key accounts and ensuring customer satisfaction.

• I need to collaborate with internal t
Answered by AI
Add your answer

Q1. Why do you want to join?
Ans. 
I am passionate about building strong relationships with key accounts and driving business growth.
• I have a proven track record of successfully managing key accounts in my previous roles.

• I am excited about the opportunity to work with a reputable company like yours and contribute to its success.

• I am motivated by the challenge of meeting and exceeding sales targets through strategic account management.

• I believe my skills...read more
Answered by AI
Add your answer
Q2. Last ctc and expectations?
Ans. 
Last CTC was $80,000 and expectations are $100,000.
• Last CTC: $80,000

• Expectations: $100,000
Answered by AI
Add your answer

Q1. Puzzle from geekforgeeks of 10 Identical peels
Add your answer
Q2. What is your daily task as a team lead?
Ans. 
As a team lead, my daily tasks include overseeing project progress, assigning tasks, providing guidance and support to team members, and ensuring deadlines are met.
• Overseeing project progress and ensuring tasks are completed on time

• Assigning tasks to team members based on their strengths and workload

• Providing guidance and support to team members to help them succeed

• Communicating with stakeholders to provide updates on ...read more
Answered by AI
Add your answer
Q3. How do you store database credentials in cloud?
Ans. 
Database credentials can be stored securely in cloud using encryption, environment variables, and key management services.
• Use encryption to protect sensitive information such as passwords and keys.

• Store credentials in environment variables rather than hardcoding them in code.

• Utilize key management services provided by cloud providers for secure storage and access control.

• Avoid storing credentials in plain text files or...read more
Answered by AI
Add your answer
Q4. If a Kubernetes secret server goes down, where to store database credentials?
Ans. 
Database credentials can be stored in a secure external vault service like HashiCorp Vault or AWS Secrets Manager.
• Store database credentials in a secure external vault service like HashiCorp Vault or AWS Secrets Manager.

• Utilize Kubernetes secrets to store the access credentials for the external vault service.

• Implement proper access controls and encryption mechanisms to ensure the security of the stored credentials.
Answered by AI
Add your answer
Q5. Do you have experience with React?
Ans. 
Yes, I have experience with React.
• I have worked on multiple projects using React for front-end development.

• I am proficient in using React components, state management, and hooks.

• I have integrated React with backend technologies like Node.js for full-stack development.
Answered by AI
Add your answer

Q1. About scrum values
Add your answer
Q2. Agile methodology
Add your answer

Q1. Dependency management
Add your answer
Q2. Scrum values and core principle
Add your answer

Q1. Salary negotiations
Add your answer
Q2. Reasons for job change
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Desire for career advancement

• Interest in working on new projects

• Seeking a more challenging role

• Opportunity to learn new skills
Answered by AI
Add your answer

Q1. What were your Roles & responsibilities in the past organisation?
Add your answer
Q2. Why do you want to change the current company?
Add your answer

Q1. Python code to calculate the sum
Ans. 
Python code to calculate the sum of elements in a list
• Use the built-in sum() function in Python to calculate the sum of elements in a list

• Create a list of numbers and pass it as an argument to the sum() function

• Example: numbers = [1, 2, 3, 4, 5] total = sum(numbers) print(total)
Answered by AI
Add your answer
Q2. Terraform code debug and analysis
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Why you want to join Style Baazar?
Add your answer