Filter interviews by
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
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
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...
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...
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?
Top trending discussions
SDLC model consists of 6 stages: planning, analysis, design, implementation, testing, and maintenance.
Planning: Define project scope, objectives, and requirements.
Analysis: Gather and analyze user requirements.
Design: Create a detailed design of the system.
Implementation: Develop and code the system.
Testing: Verify that the system meets requirements and is error-free.
Maintenance: Make changes and updates to the system
Product analysis involves researching, evaluating, and making recommendations for product improvements.
Researching market trends and customer needs
Analyzing product performance data
Identifying areas for improvement and making recommendations
Collaborating with cross-functional teams to implement changes
Monitoring and evaluating the impact of changes
Continuously iterating and improving the product
I applied via Recruitment Consulltant and was interviewed before Mar 2023. There were 2 interview rounds.
I applied via Naukri.com and was interviewed before Dec 2021. There were 2 interview rounds.
I was interviewed in Oct 2024.
I led a project to implement a new automated production line, increasing efficiency by 30%.
Researched and selected the best equipment for the production line
Managed the installation and testing of the new machinery
Trained staff on how to operate and maintain the automated system
How will you reduce the returns
I failed to meet a production deadline due to unforeseen issues, but I overcame it by adjusting the schedule and reallocating resources.
Identify the reasons for the failure
Communicate with team members and stakeholders about the situation
Develop a new plan with revised timeline and resource allocation
Implement the new plan effectively to meet the deadline
60 mins of aptitude test
60 mins of coding round
OOPs concepts revolve around classes, objects, inheritance, polymorphism, and encapsulation.
Classes are blueprints for objects, defining their properties and behaviors.
Objects are instances of classes, representing real-world entities.
Inheritance allows a class to inherit properties and methods from another class.
Polymorphism enables objects to be treated as instances of their parent class.
Encapsulation restricts acces...
I am a dedicated and experienced Production Engineer with a strong background in manufacturing processes and quality control.
Bachelor's degree in Mechanical Engineering
5+ years of experience in production engineering
Proficient in CAD software and manufacturing processes
Implemented lean manufacturing principles to improve efficiency
Led cross-functional teams to troubleshoot production issues
Unix is a powerful operating system known for its multitasking and multi-user capabilities, while SQL is a language used for managing and querying databases.
Unix is an operating system developed in the 1970s known for its command-line interface and flexibility.
SQL (Structured Query Language) is a language used to communicate with databases to retrieve, update, and manage data.
Unix commands are case-sensitive and often ...
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
A mutex is a synchronization primitive used to control access to shared resources in a multi-threaded environment.
Mutex is typically used to protect critical sections of code to prevent race conditions.
Syntax for using mutex in C++: std::mutex myMutex;
To lock a mutex: myMutex.lock();
To unlock a mutex: myMutex.unlock();
A goroutine is a lightweight thread managed by the Go runtime. It allows concurrent execution of functions.
Goroutines are created using the 'go' keyword followed by a function call.
They are used for concurrent programming in Go, allowing multiple functions to run simultaneously.
Goroutines are more efficient than traditional threads as they have lower memory overhead and can be multiplexed onto fewer OS threads.
Example:...
DSA, Queries and logical coding
Territory Sales Manager
7
salaries
| ₹5.3 L/yr - ₹9.5 L/yr |
Area Sales Manager
5
salaries
| ₹7.5 L/yr - ₹11.3 L/yr |
Software Engineer
4
salaries
| ₹15 L/yr - ₹21 L/yr |
Business Analyst
4
salaries
| ₹4.8 L/yr - ₹10 L/yr |
Business Development Manager
4
salaries
| ₹8.5 L/yr - ₹9.5 L/yr |
Flipkart
Amazon
Snapdeal
Paytm Mall