XimKart Interview Questions and Answers

Q1. Which is more efficient: Common Table Expressions (CTEs) or Subqueries?
Ans. 
CTEs are generally more efficient than subqueries due to their ability to be reused and optimized by the query planner.
• CTEs can be referenced multiple times within a query, reducing the need to repeat the same subquery logic.

• CTEs can improve query readability and maintainability by breaking down complex logic into smaller, more manageable parts.

• CTEs can be optimized by the query planner, potentially leading to better p...read more
Answered by AI
Add your answer
Q2. What is the difference between relational and non-relational databases, and can you provide examples of each?
Ans. 
Relational databases store data in tables with predefined relationships, while non-relational databases store data in flexible, schema-less formats.
• Relational databases use structured query language (SQL) for querying data

• Non-relational databases are more flexible and can store data in various formats like key-value pairs, documents, graphs, etc.

• Examples of relational databases include MySQL, Oracle, and SQL Server

• Exam...read more
Answered by AI
Add your answer
Q3. What is the method to obtain a running total per month for a given sales data set, and how can the three-month moving average of total sales be calculated?
Ans. 
Running total per month can be obtained by summing the sales data for each month. Three-month moving average can be calculated by averaging the total sales for the current month and the two previous months.
• To obtain a running total per month, sum the sales data for each month.

• To calculate the three-month moving average of total sales, average the total sales for the current month and the two previous months.

• Example: Ru...read more
Answered by AI
Add your answer

A client is experiencing frequent stockouts and resulting revenue loss. How would you conduct a root cause analysis to identify the bottlenecks in the supply chain? What model would you choose to create a predictive sales model and enhance the process of calculating reorder points to avoid stockouts?

Q1. Introduction and what you did in current company`
Ans. 
I have been working as a Sourcing Manager in my current company for the past 3 years.
• Managed supplier relationships and negotiations

• Developed sourcing strategies to reduce costs and improve quality

• Collaborated with cross-functional teams to ensure supply chain efficiency
Answered by AI
Add your answer
Q2. Manufacturing and Procurement related question
Add your answer

Q1. Current package
Add your answer
Q2. Current Location
Ans. 
I am currently located in New York City.
• I am based in New York City

• I have been living in New York for the past 5 years

• My current address is in Manhattan, New York
Answered by AI
Add your answer

Q1. Reverse a stack using recursion
Ans. 
Reverse a stack using recursion
• Use recursion to remove each element from the stack and store it in a temporary variable

• Recursively call the reverse function on the remaining stack

• Push the temporary variable back into the reversed stack
Answered by AI
Add your answer

Q1. Design a Invoice generation system
Ans. 
Design a system for generating invoices.
• Identify the necessary data for an invoice (e.g. customer information, item details, pricing)

• Create a database schema to store invoice data

• Develop a user interface for entering invoice information

• Implement logic to calculate totals, taxes, and discounts

• Generate a PDF or printable version of the invoice

• Include functionality for tracking invoice status and payment

• Consider security ...read more
Answered by AI
Add your answer

Q1. 1. About prev work experience 2. Solve the problem in a multi format data ingestion module. 3. Lot of behavioural and team fitment questions
Add your answer

Q1. Can you provide an introduction of yourself along with your work experience?
Ans. 
Dynamic Territory Sales Manager with over 7 years of experience driving sales growth and building strong client relationships.
• Over 7 years of experience in sales, focusing on territory management and client acquisition.

• Successfully increased sales by 30% in my previous role by implementing targeted marketing strategies.

• Skilled in building and maintaining relationships with key clients, resulting in a 95% customer reten...read more
Answered by AI
Add your answer
Q2. What are the achievements you have accomplished in your work?
Ans. 
I have consistently exceeded sales targets, built strong client relationships, and implemented successful marketing strategies.
• Achieved 120% of sales target in the last fiscal year by expanding the client base through targeted outreach.

• Developed and executed a marketing campaign that increased product awareness, resulting in a 30% sales increase in a key territory.

• Established long-term relationships with key clients, l...read more
Answered by AI
Add your answer