Desai & Diwanji 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. Convert gallon (us) to litre
Add your answer
Q2. What is the standard drying conditions
Add your answer

Q1. Binary search question
Add your answer
Q2. Heap question dsa
Add your answer
Q3. Level order traversal binary tree
Add your answer

Q1. Natural language processing
Add your answer

Q1. Machine learning and natural language processing
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

Q1. What are your skills?
Add your answer
Q2. How can you overcome challenges ?
Add your answer

Q1. Enforcement of Equitable Mortgage and Registered Mortgage
Ans. 
Enforcement of Equitable Mortgage and Registered Mortgage involves different legal processes and remedies.
• Equitable mortgage is created by deposit of title deeds while registered mortgage is created by registration with the land registry.

• Enforcement of equitable mortgage involves filing a suit for foreclosure or sale of the property.

• Enforcement of registered mortgage involves initiating foreclosure proceedings through ...read more
Answered by AI
Add your answer
Q2. Types of mortgage
Ans. 
There are various types of mortgages, including fixed-rate, adjustable-rate, FHA, VA, and jumbo loans.
• Fixed-rate mortgages have a set interest rate for the entire term of the loan.

• Adjustable-rate mortgages have an interest rate that can change periodically.

• FHA loans are insured by the Federal Housing Administration and often require a lower down payment.

• VA loans are guaranteed by the Department of Veterans Affairs and ...read more
Answered by AI
Add your answer

Q1. Basics of angular
Add your answer

Crud with angular and with the basic logic in 1hr duration