Blue Yonder Plsql Developer Interview Questions and Answers

Q1. SQL based questions
Add your answer
Q2. PLSQL based questions
Add your answer

Q1. Questioned about each and every objects in database. procedures, functions with examples write Fibonacci series using plsql block joins, subqueries written a sql query to fetch weekdays
Add your answer

Q1. Basic questions on oops, exception handling, spring boot annotations, collections
Add your answer

Q1. Coding questions on Java 8 features, streams, lambdas as well
Add your answer

Q1. This is was kind of managerial round. Goes with questions like what is your learning, why job switch, difficult part of your job and some puzzles as well
Add your answer

Q1. Questions like self intro, fam background, why manhattan, what do you know about manhattan, package, strengths and weakness
Add your answer

Q1. Just go through basic core java questions, spring boot questions.
Add your answer
Q2. 1. Oops concept, Exception Handling, Singleton class
Add your answer

Q1. 1. Find number of times a string occurs in second string. Practice more on string coding interview questions. 2. Sql:find employee who has second highest salary.
Ans. 
Count occurrences of a string in another string and find second highest salary in SQL.
• Use a loop to iterate through the second string and check for occurrences of the first string.

• Use a counter variable to keep track of the number of occurrences found.

• In SQL, use a subquery to find the employee with the second highest salary by ordering the salaries in descending order and selecting the second row.
Answered by AI
Add your answer

Q1. Discussed about roles and responsibilities. Greatest challenge that has faced in job role. Puzzle:u have 3l 5l container,how do u measure 4l using only two given containers
Add your answer

Round 1 was of aptitude test with two sections overall it was easy but very less time.

Q1. Core java and advance java , project what u have done and puzzles
Add your answer

Java Coding Questions based on ArrayList, HashMap, etc.

Count distinct elements in given String.

Q1. Current Project architecture.
Ans. 
Our current project architecture follows a microservices design pattern with separate services for different functionalities.
• Microservices architecture with separate services for different functionalities

• Use of RESTful APIs for communication between services

• Containerization using Docker for easy deployment and scalability

• Implementation of service discovery and load balancing with tools like Kubernetes

• Use of message bro
Answered by AI
Add your answer
Q2. My role in project
Ans. 
My role in the project was to develop and maintain Java applications to meet the project requirements.
• Developing Java applications based on project requirements

• Maintaining and updating existing Java code

• Collaborating with team members to ensure project success
Answered by AI
Add your answer

Q1. Core java basics
Add your answer
Q2. Collections framework
Add your answer