Lavender Technology Team Lead Interview Questions and Answers

Q1. Performance optimisation
Add your answer

Q1. Lods,parameters
Add your answer

Q1. Sql queries on analytical queries
Add your answer
Q2. Different constraints and join methods
Ans. 
Different constraints and join methods in database queries
• Constraints in database queries ensure data integrity and enforce rules on data

• Join methods in database queries are used to combine rows from two or more tables based on a related column between them

• Examples of constraints include primary key, foreign key, unique key, and check constraints

• Examples of join methods include inner join, outer join (left, right, full
Answered by AI
Add your answer

It was mostly on sub queries.

Q1. Waste of time to go Mphasis
Ans. 
It depends on individual circumstances and career goals.
• Going to Mphasis may not be a waste of time if it aligns with your career goals and offers valuable experience.

• Consider factors such as job role, growth opportunities, work culture, and learning potential before making a decision.

• Some people may find Mphasis to be a valuable stepping stone in their career, while others may not see it as beneficial.

• Ultimately, the ...read more
Answered by AI
Add your answer

Q1. Write a join in sql
Ans. 
A SQL join is used to combine rows from two or more tables based on a related column between them.
• Use the JOIN keyword to specify the tables to be joined

• Use the ON keyword to specify the column to join on

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Answered by AI
Add your answer
Q2. Java related many questions
Add your answer

Q1. Explain your project in details
Add your answer
Q2. Write 2 any joins in sql
Ans. 
Two common SQL joins are INNER JOIN and LEFT JOIN.
• 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.
Answered by AI
Add your answer

Q1. How are you doing
Add your answer
Q2. Which was your previous institution
Add your answer

Q1. HOW JVM works ?
Ans. 
JVM is a virtual machine that executes Java bytecode. It manages memory, provides security, and facilitates garbage collection.
• JVM loads the bytecode generated by the Java compiler and interprets it.

• It uses Just-In-Time (JIT) compilation to improve performance by compiling frequently used code into native machine code.

• JVM manages memory through garbage collection, freeing up memory occupied by objects that are no longe...read more
Answered by AI
Add your answer
Q2. Hash Map internal working?
Ans. 
Hash Map is a data structure that stores key-value pairs and uses a hash function to map keys to their corresponding values.
• Hash Map uses a hash function to determine the index of the key-value pair in the underlying array.

• Collisions can occur when multiple keys hash to the same index, which can be resolved using techniques like chaining or open addressing.

• Hash Map provides constant time complexity O(1) for insertion,
Answered by AI
Add your answer

Q1. What is stereo annotation ?
Ans. 
Stereo annotation is the process of labeling or tagging images or videos with depth information to create a 3D effect.
• Stereo annotation involves identifying corresponding points in a pair of images or frames to determine depth perception.

• It is commonly used in computer vision tasks such as object detection, tracking, and scene understanding.

• Examples of stereo annotation include creating depth maps for autonomous drivin
Answered by AI
Add your answer
Q2. Muti threading.
Add your answer

Q1. String based question.
Add your answer
Q2. Hashmap based question and internal working of hash map. Streams
Add your answer

Q1. Java stream apis
Add your answer

Q1. Salary discussion n notice period
Add your answer

Q1. Basic java 8 questions
Add your answer

On risk assessment and as well as case study

Q1. Salary expectations
Add your answer
Q2. Job location etc etc
Add your answer