XimKart Interview Questions, Process, and Tips

Q1. Few DSA questions
Add your answer

Q1. Design patterns
Add your answer

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
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
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