i
ffreedom
app
Filter interviews by
I applied via LinkedIn and was interviewed before Jan 2024. There was 1 interview round.
The SQL query for calculating a moving average involves using window functions.
Use the OVER clause with the ORDER BY clause to define the window frame for the moving average calculation.
Use the AVG() function to calculate the average within the window frame.
Example: SELECT value, AVG(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS moving_avg FROM table_name;
DDL is used to define the structure of database objects, while DML is used to manipulate data within those objects.
DDL is used to create, modify, and delete database objects such as tables, indexes, and views.
DML is used to insert, update, retrieve, and delete data within those database objects.
Examples of DDL statements include CREATE TABLE, ALTER INDEX, and DROP VIEW.
Examples of DML statements include INSERT INTO, UP...
Top trending discussions
I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
2 SQL questions asked
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
I am a highly motivated and detail-oriented individual with a background in marketing and a passion for data analysis.
Background in marketing
Passion for data analysis
Highly motivated and detail-oriented
I chose BPO because of the opportunity to work with diverse clients, develop strong communication skills, and gain valuable experience in a fast-paced environment.
Opportunity to work with diverse clients
Develop strong communication skills
Gain valuable experience in a fast-paced environment
I am a highly motivated and detail-oriented individual with a background in marketing and a passion for project management.
Background in marketing
Passion for project management
Detail-oriented
Highly motivated
Sales is the process of selling products or services to customers by understanding their needs and providing solutions.
Build rapport with the customer by actively listening and asking questions to understand their needs
Highlight the benefits of the product or service that meet the customer's needs
Handle objections by addressing concerns and providing additional information or alternatives
Close the sale by asking for th...
I applied via Job Portal and was interviewed in Apr 2024. There was 1 interview round.
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
Warehouse operations involve the management of inventory, storage, and distribution to ensure efficient supply chain processes.
Inventory Management: Keeping track of stock levels, orders, and deliveries to prevent overstocking or stockouts, e.g., using barcode systems.
Receiving and Inspection: Checking incoming shipments for accuracy and quality, ensuring that products meet specifications before storage.
Storage Solutio...
I would segregate rejected items, analyze the reasons for rejection, and work with suppliers to address the issues.
Segregate rejected items to prevent mixing with approved items
Analyze reasons for rejection to identify trends and common issues
Work with suppliers to address quality issues and prevent future rejections
Questions were on sql , python and java
Duration was 10 minutes
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
It is impossible to accurately estimate the number of women driving red cars in Bangalore without specific data.
There is no specific data available on the number of women driving red cars in Bangalore.
Estimating the number of women driving red cars in Bangalore would require access to vehicle registration data or a survey of car owners.
Factors such as car ownership trends among women and the popularity of red cars woul...
Achieve GMV by optimizing marketing channels, improving product offerings, and enhancing user experience.
Optimize marketing channels to reach a larger audience
Improve product offerings to increase customer interest and sales
Enhance user experience to encourage repeat purchases and higher order values
I appeared for an interview before Oct 2023.
based on 1 interview experience
Difficulty level
Duration
Relationship Manager
335
salaries
| ₹0.8 L/yr - ₹6 L/yr |
Team Lead
145
salaries
| ₹2 L/yr - ₹4 L/yr |
Associate Sales Manager
80
salaries
| ₹2 L/yr - ₹4.5 L/yr |
Assistant Manager
45
salaries
| ₹3.5 L/yr - ₹7 L/yr |
Customer Relationship Manager
23
salaries
| ₹1.1 L/yr - ₹3.6 L/yr |
Udaan
Swiggy
Oyo Rooms
Blinkit