Shardul Amarchand Mangaldas Interview Questions and Answers

Two hours and 32 questions

Q1. Write commands for DML
Ans. 
DML commands are used to manipulate data in a database. Examples include INSERT, UPDATE, DELETE.
• INSERT: Adds new data into a table

• UPDATE: Modifies existing data in a table

• DELETE: Removes data from a table
Answered by AI
Add your answer
Q2. Write commands for Joins
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• INNER JOIN: Returns rows when there is at least one match in both tables

• LEFT JOIN: Returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table

• FULL JOIN: Returns rows when there is a match in one of the tables
Answered by AI
Add your answer

Q1. Ask questions regarding advance excel
Add your answer
Q2. Ask questions from Power BI
Add your answer

Q1. Take me through your profile?
Ans. 
Experienced Senior Manager with a proven track record in leading teams and driving business growth.
• Over 10 years of experience in management roles

• Successfully led cross-functional teams to achieve project milestones

• Implemented strategies that resulted in a 20% increase in revenue

• Strong communication and leadership skills

• MBA in Business Administration from XYZ University
Answered by AI
Add your answer
Q2. Why do you want to change ?
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for new challenges and learning experiences

• Opportunity for career advancement

• Seeking a more dynamic work environment

• Wish to broaden skill set and knowledge

• Desire for increased responsibility and leadership roles
Answered by AI
Add your answer

Q1. Questions related to Strategic sourcing?
Add your answer

Q1. Explain about job description
Add your answer

Q1. Checking communication skills
Add your answer
Q2. Self introduction
Add your answer
Q3. Basic questions about ticketingtool
Add your answer

Q1. Previous experience
Add your answer
Q2. Question on automobiles
Add your answer

Q1. Convert gallon (us) to litre
Add your answer
Q2. What is the standard drying conditions
Add your answer

Q1. Tell me About yourself
Add your answer
Q2. Tell me about your past experience and CTC
Add your answer

Test of contract abstraction

Q1. Tell me about your self
Add your answer
Q2. Tell me about patent the and its tenure
Ans. 
A patent is a legal protection granted to inventors for their inventions, giving them exclusive rights for a certain period of time.
• Patents are granted by government agencies to protect the intellectual property of inventors.

• The tenure of a patent is typically 20 years from the date of filing, during which the inventor has exclusive rights to the invention.

• During the tenure of a patent, the inventor can prevent others ...read more
Answered by AI
Add your answer
Q3. Tell me about past experience
Ans. 
I have 2 years of experience working as a customer service representative in a call center.
• Handled customer inquiries and resolved complaints

• Provided product information and assistance with orders

• Maintained accurate records of customer interactions

• Collaborated with team members to improve customer satisfaction

• Received positive feedback from supervisors for excellent communication skills
Answered by AI
Add your answer

Q1. Is there any difference in the R&Ws provided to minority v majority shareholders?
Ans. 
R&Ws provided to minority and majority shareholders may differ based on the terms of the agreement and the rights of each group.
• R&Ws may vary based on the percentage of ownership held by minority vs majority shareholders.

• Majority shareholders may have more influence in negotiating the terms of the R&Ws.

• Minority shareholders may have specific protections in place to safeguard their interests.

• The specific terms of the R&...read more
Answered by AI
Add your answer
Q2. Can ESOPs be issued to promoters and directors of company?
Ans. 
Yes, ESOPs can be issued to promoters and directors of a company.
• ESOPs can be issued to promoters and directors as long as they are employees of the company.

• Promoters and directors may receive ESOPs as part of their compensation package.

• ESOPs can help align the interests of promoters and directors with those of the company and its shareholders.
Answered by AI
Add your answer