Phenom Technical Support Lead Interview Questions, Process, and Tips

Q1. Find the last 2 row in sql?
Add your answer

Q1. Transaction in Spring Boot
Ans. 
Transactions in Spring Boot help manage database operations as a single unit of work.
• Transactions ensure ACID properties (Atomicity, Consistency, Isolation, Durability) for database operations.

• Use @Transactional annotation to mark a method as transactional.

• Transactions can be managed programmatically using TransactionTemplate.

• Rollback can be triggered manually in case of exceptions.

• Spring Boot supports both declarative
Answered by AI
Add your answer
Q2. Java Array and problem solving
Add your answer

Q1. Questions were mostly around system design, you will be given a case like a stock system and specific use case is asked to design end to end from UI to backend.
Add your answer
Q2. Some of the system debugging/performance improvement questions are asked from both UI and backend.
Add your answer

Q1. Basic questions in SQL , Linux , shell scripting
Add your answer

Q1. Technical discussion round and simply good and I have give all the answers perfectly.
Add your answer

20 questions on logical and mathematical

Q1. Puzzles and coding questions
Add your answer

Questions related to apti sql comprehension and psuedocode were asked. 30 mins for 25 questions wos provided.

Q1. Round 2 is technical interview.
Add your answer

Q1. Implement minstack
Add your answer
Q2. How load balancers work
Ans. 
Load balancers distribute incoming network traffic across multiple servers to ensure no single server is overwhelmed.
• Load balancers monitor the health of servers and distribute traffic based on predefined algorithms.

• They can be hardware-based or software-based.

• Common algorithms used by load balancers include round-robin, least connections, and IP hash.

• Load balancers can improve reliability and scalability of a website ...read more
Answered by AI
Add your answer

Q1. 2 sum problem to implement in O(n)
Ans. 
The Two Sum problem involves finding two numbers in an array that add up to a target value.
• Iterate through the array and store the difference between the target and current element in a hashmap.

• Check if the current element exists in the hashmap, if yes, return the indices of the current element and the stored difference.

• Time complexity of O(n) can be achieved by using a hashmap to store elements and their indices.
Answered by AI
Add your answer
Q2. About the projects i have done
Add your answer

Basic aptitude and easy to crack

In group discussion you need to check with your fluency and then your grammar and everything

Q1. About project few questions
Add your answer
Q2. Task will be given and you need to complete
Add your answer