R.K.Dewan & Co. 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. 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. What are the steps to generate a Universal Account Number (UAN) for employees?
Ans. 
Steps to generate UAN for employees
• Employer logs in to the EPFO employer portal

• Selects 'Member' and then 'Register Individual' to generate UAN

• Enters employee details like Aadhaar, PAN, bank account, etc.

• UAN is generated and provided to the employee

• Employee can activate UAN on the EPFO member portal
Answered by AI
Add your answer
Q2. How do you manage compliance with Provident Fund regulations and associated penalties?
Ans. 
Managing compliance with Provident Fund regulations involves regular audits, timely deposits, and staying updated on changes.
• Conduct regular audits to ensure accurate Provident Fund contributions

• Timely deposit employee and employer contributions to avoid penalties

• Stay updated on changes in Provident Fund regulations to ensure compliance

• Train HR and operations staff on Provident Fund rules and procedures

• Maintain detaile...read more
Answered by AI
Add your answer

Q1. What is strength
Ans. 
Strength is the ability to overcome challenges and obstacles, both physically and mentally.
• Physical strength is the ability to exert force and lift heavy objects.

• Mental strength is the ability to stay resilient in the face of adversity.

• Strength can also refer to emotional resilience and the ability to cope with difficult situations.

• Examples include weightlifters showcasing their physical strength and individuals overco...read more
Answered by AI
Add your answer
Q2. What is five years roadmap
Ans. 
A five-year roadmap is a strategic plan outlining goals and objectives for the next five years.
• Identify long-term goals and objectives

• Break down goals into smaller milestones

• Allocate resources and budget accordingly

• Regularly review and adjust the roadmap based on progress

• Communicate the roadmap to stakeholders for alignment
Answered by AI
Add your answer

Inquiring about fundamental grammar to achieve at least the minimum passing score

Q1. What are the basic details about yourself, and why are you particularly interested in this role and the company?
Ans. 
Experienced student counsellor passionate about helping young individuals navigate challenges and achieve personal growth.
• Over 5 years of experience in providing counselling services to students in various educational settings

• Strong communication and interpersonal skills to build trust and rapport with students

• Passionate about supporting young individuals in overcoming obstacles and reaching their full potential

• Familia...read more
Answered by AI
Add your answer