DSG Interview Questions and Answers

Test included 3-4 coding questions

Q1. Questions related to HTML like components of a document, what are inline and block elements , what are forms in html and different input types
Add your answer
Q2. Difference in delete, drop and truncate in sql
Ans. 
Delete removes specific rows, drop removes entire table, truncate removes all rows in a table.
• Delete is used to remove specific rows from a table based on a condition.

• Drop is used to remove an entire table along with its structure and data.

• Truncate is used to remove all rows from a table but keeps the table structure intact.

• Delete is slower than truncate and drop as it logs each row deletion.

• Drop is faster than delete ...read more
Answered by AI
Add your answer
Q3. Why javascript is used
Ans. 
JavaScript is used for creating interactive web pages and web applications.
• JavaScript allows for dynamic content on websites

• It can be used for client-side validation and form handling

• JavaScript frameworks like React and Angular are popular for building single-page applications
Answered by AI
Add your answer
Q4. Questions on concept of OOPs like on encapsulation
Add your answer

Q1. What is profit and loss statement
Ans. 
A profit and loss statement is a financial report that summarizes a company's revenues, expenses, and profits over a specific period of time.
• It shows the company's total revenue, total expenses, and net income or loss.

• It helps in analyzing the financial performance of the business.

• It is also known as an income statement.

• Example: A profit and loss statement for a restaurant would include revenue from food sales, expense...read more
Answered by AI
Add your answer
Q2. What is beverage cost
Ans. 
Beverage cost refers to the total cost of all beverages sold in a restaurant compared to the revenue generated from those sales.
• Beverage cost is calculated by dividing the total cost of beverages by the total revenue from beverage sales.

• It is important for restaurant managers to closely monitor beverage cost to ensure profitability.

• Lowering beverage cost can be achieved through effective inventory management, pricing s...read more
Answered by AI
Add your answer
Q3. What is food cost
Ans. 
Food cost is the total cost of ingredients used to prepare a dish or menu item.
• Food cost is calculated by adding up the cost of all ingredients used in a recipe.

• It is typically expressed as a percentage of the menu price, with the goal of keeping it below a certain threshold to ensure profitability.

• For example, if a dish costs $5 to make and is sold for $15, the food cost percentage would be 33%.
Answered by AI
Add your answer
Q4. How to calculate the food and beverage cost
Ans. 
Food and beverage cost can be calculated by dividing the total cost of food and beverages by the total revenue generated from food and beverages.
• Calculate the total cost of food and beverages purchased during a specific period.

• Calculate the total revenue generated from food and beverages during the same period.

• Divide the total cost by the total revenue to get the food and beverage cost percentage.

• For example, if the to...read more
Answered by AI
Add your answer
Q5. What are the line items of P&L
Ans. 
Line items of P&L include revenue, cost of goods sold, gross profit, operating expenses, net income.
• Revenue: total income generated from sales

• Cost of Goods Sold: direct costs associated with producing goods sold

• Gross Profit: revenue minus cost of goods sold

• Operating Expenses: costs incurred in running the business (e.g. rent, utilities, salaries)

• Net Income: total profit after all expenses are deducted
Answered by AI
Add your answer
Q6. What is yeast .. how it works
Ans. 
Yeast is a type of fungus used in baking and brewing to help dough rise and ferment liquids.
• Yeast is a single-celled organism that feeds on sugars and produces carbon dioxide gas and alcohol as byproducts.

• It is commonly used in baking to leaven bread and create a light, airy texture.

• Yeast is also used in brewing to ferment sugars in grains or fruits to produce alcohol.

• There are different types of yeast, such as active ...read more
Answered by AI
Add your answer
Q7. French region with wines...
Ans. 
The French region known for its wines is Bordeaux.
• Bordeaux is famous for its red wines, particularly Cabernet Sauvignon and Merlot blends.

• The region is divided into sub-regions like Medoc, Saint-Emilion, and Pomerol.

• Bordeaux also produces white wines, sweet wines like Sauternes, and sparkling wines.
Answered by AI
Add your answer
Q8. Where hospitality comes from
Ans. 
Hospitality comes from a genuine desire to make others feel welcome, comfortable, and valued.
• Hospitality is rooted in empathy and kindness towards others

• It involves creating a warm and inviting atmosphere for guests

• Good hospitality includes attentiveness, good communication, and problem-solving skills

• Examples: greeting guests with a smile, anticipating their needs, resolving any issues promptly
Answered by AI
Add your answer

They asked a multiple-choice question.

SQL based questions and c#