i
Vyapar
Filter interviews by
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
Basic Hacker Rank SQL Questions 2 . and 10 MCQ based
The query selects all columns and calculates the total amount for each customer in table t2.
The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.
The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.
The 'select *' statement selects all columns from the table along with the calculated total amount.
The 'sum(amt) over (partiti...
To find customers who purchased the same item multiple times on the same day.
Identify unique customers who purchased the same item multiple times on the same day
Check for duplicate transactions by customer and item on the same day
Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
6 mcqs and 2 sql questions
In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.
HAVING is used with GROUP BY to filter groups based on aggregate functions
WHERE is used to filter rows before grouping
HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;
Example: S
I applied via Instahyre and was interviewed in Jul 2024. There were 3 interview rounds.
HackerEarth based assessment.
1. 8 qs were stats & prob based multiples choices
2. 2 were medium level sql questions.
I applied via Company Website and was interviewed in Apr 2024. There were 2 interview rounds.
Consisted of 10 questions, 2 SQL medium level questions and remaining easy aptitude, profit loss, work time etc
Vyapar interview questions for designations
SQL+CODING QUESTIONS
I applied via campus placement at Indian Institute of Technology (IIT), Roorkee and was interviewed in Sep 2023. There were 3 interview rounds.
It was very easy and out of 1000 students 300 students got shortlisted.
OOPs stands for Object-Oriented Programming. The 4 pillars are Inheritance, Encapsulation, Abstraction, and Polymorphism.
Inheritance: Allows a class to inherit properties and behavior from another class. Example: Parent class 'Animal' and child class 'Dog' inheriting from 'Animal'.
Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Using private variables and public methods in...
DBMS stands for Database Management System, which is a software system that manages databases. SQL is a language used to interact with databases.
DBMS is a software system that allows users to define, create, maintain, and control access to databases.
SQL (Structured Query Language) is a language used to communicate with a database. It is used to retrieve, update, and manage data in a database.
Examples of popular DBMS in...
MongoDB is a NoSQL database program that uses a document-oriented data model.
NoSQL database program
Document-oriented data model
Uses JSON-like documents for data storage
Supports dynamic schemas for flexible data structures
React hooks are functions that let you use state and other React features without writing a class.
Hooks are functions that let you use state and other React features in functional components
useState() - allows functional components to have local state
useEffect() - allows functional components to perform side effects
useContext() - allows functional components to access context
useReducer() - an alternative to useState() ...
I applied via campus placement at International Institute of Information Technology (IIIT), Bangalore and was interviewed in Oct 2022. There were 4 interview rounds.
Consisting of around 10 SQL querying questions and 2 Python programming questions and 30 SQL + PowerBI related MCQs
I applied via Naukri.com and was interviewed in May 2024. There were 3 interview rounds.
based on 7 interviews
2 Interview rounds
based on 1 review
Rating in categories
Business Development Executive
133
salaries
| ₹2.8 L/yr - ₹5.2 L/yr |
Inside Sales Executive
91
salaries
| ₹2.2 L/yr - ₹5 L/yr |
Accounts Manager
83
salaries
| ₹2.8 L/yr - ₹5 L/yr |
Team Lead
81
salaries
| ₹3.7 L/yr - ₹7.7 L/yr |
Customer Support Executive
64
salaries
| ₹2.8 L/yr - ₹4.2 L/yr |
Zoho
Tally Solutions
MARG ERP
Busy Infotech