Vyapar Interview Questions, Process, and Tips for Freshers

6 mcqs and 2 sql questions

Q1. Difference between having and where in sql
Ans. 
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
Answered by AI
Add your answer
Q2. Sql joins and it types
Add your answer
Q3. Window functions and subqueries
Add your answer
Q4. Sql scenario question based on joins
Add your answer
Q5. Kpi's and metrics
Add your answer

Q1. Business problem related to case study
Add your answer

Mathematical questions was given for aptitude test which is basic if you know formulas pretty well u can easily score

Q1. Situation based
Add your answer
Q2. General knowledge of accounting
Add your answer

In aptitude test there are 10 questions from percentage profit loss and reasoning direction test etc.

Q1. GST and its types
Ans. 
GST stands for Goods and Services Tax, a value-added tax levied on most goods and services sold for domestic consumption.
• GST is a consumption tax that is imposed on the supply of goods and services.

• There are different types of GST, such as CGST (Central Goods and Services Tax), SGST (State Goods and Services Tax), and IGST (Integrated Goods and Services Tax).

• CGST is collected by the central government, SGST by the stat...read more
Answered by AI
Add your answer
Q2. A situation to sell a duster.
Ans. 
I would highlight the benefits of using a duster for cleaning and dusting tasks.
• Explain how a duster can easily remove dust and dirt from surfaces

• Mention the convenience of using a duster for hard-to-reach areas

• Highlight the effectiveness of a duster in reducing allergens and improving air quality
Answered by AI
Add your answer
Q3. What is accounting and balanced sheet
Ans. 
Accounting is the process of recording, summarizing, and analyzing financial transactions of a business. A balance sheet is a financial statement that shows a company's assets, liabilities, and equity at a specific point in time.
• Accounting involves recording financial transactions, summarizing them in financial statements, and analyzing the results.

• A balance sheet is a financial statement that shows a company's assets ...read more
Answered by AI
Add your answer

Just your previous job

Q1. Just your basic introduction
Add your answer