Premium Employer

i

This company page is being actively managed by Blue Yonder Team. If you also belong to the team, you can get access from here

Blue Yonder Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Blue Yonder Plsql Developer Interview Questions and Answers

Updated 24 Apr 2024

Blue Yonder Plsql Developer Interview Experiences

1 interview found

Plsql Developer Interview Questions & Answers

user image Karnataka Ramyasree

posted on 24 Apr 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Write function to determine Factorial of given number? about cursors materialized view window functions Joins

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Sep 2022. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Some questions of database like types of joins, second highest salary from employee table
  • Q2. Delete duplicate records from table
  • Ans. 

    To delete duplicate records from a table, we can use the DELETE statement with a subquery.

    • Identify the columns that define a duplicate record.

    • Write a subquery to select the duplicate records.

    • Use the DELETE statement with the subquery to delete the duplicate records.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be prepared with basic questions also i studied complicated questions

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL based questions
  • Q2. PLSQL based questions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • 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
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic DSA questions like binary search, pattern
  • Q2. Basic SQL query questions

Interview Preparation Tips

Interview preparation tips for other job seekers - One of the worst company I have given interview,
The HR named Shubha A contacted me a day before interview that are you available for interview, I told yes.

After that interview has been scheduled, with interviewer soumyashree rout , I have given all the answers which she asked for and what did I get an acquisition of cheating in interview, I even showed her my surroundings that I am not cheating, and how come such dumb people are allowed to interview. Really waste of time and effort.

Please don't go for interview for this company you will find better opportunities like I did , offered a position at a product based company better than this.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Apr 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Just go through basic core java questions, spring boot questions.
  • Q2. 1. Oops concept, Exception Handling, Singleton class
Round 3 - One-on-one 

(1 Question)

  • 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
Round 4 - Behavioral 

(1 Question)

  • 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

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Core java basics
  • Q2. Collections framework
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Jun 2023. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Basic questions on oops, exception handling, spring boot annotations, collections
Round 3 - One-on-one 

(1 Question)

  • Q1. Coding questions on Java 8 features, streams, lambdas as well
Round 4 - One-on-one 

(1 Question)

  • 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
Round 5 - HR 

(1 Question)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - For the 3rd round, they call you to office for a F2F interview. After that HR round takes place and they just say that your interview did not yield a positive response. When you ask for feedback, they simply laugh at your face. This is the worst that can be done to an applicant.
P.S- I was a referred candidate

I applied via Approached by company and was interviewed in Dec 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Interview Preparation Tips

Topics to prepare for Dassault Systemes Java Developer interview:
  • C, c++,Java coding knowledge
Interview preparation tips for other job seekers - Employee, devolper ,tester ,coding
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

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

Round 2 - One-on-one 

(1 Question)

  • Q1. Core java and advance java , project what u have done and puzzles

Interview Preparation Tips

Topics to prepare for Dassault Systemes Java Developer interview:
  • Java
Interview preparation tips for other job seekers - for interview round prepare puzzles very well.

Blue Yonder Interview FAQs

How many rounds are there in Blue Yonder Plsql Developer interview?
Blue Yonder interview process usually has 1 rounds. The most common rounds in the Blue Yonder interview process are Technical.

Tell us how to improve this page.

Blue Yonder Plsql Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Blue Yonder Innovative supply chain solutions.

Interview Questions from Similar Companies

Oracle Interview Questions
3.7
 • 846 Interviews
SAP Interview Questions
4.2
 • 283 Interviews
Adobe Interview Questions
3.9
 • 233 Interviews
24/7 Customer Interview Questions
3.5
 • 175 Interviews
Globant Interview Questions
3.8
 • 172 Interviews
Dassault Systemes Interview Questions
4.0
 • 160 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
VMware Software Interview Questions
4.4
 • 145 Interviews
NCR Voyix Interview Questions
3.9
 • 122 Interviews
ServiceNow Interview Questions
4.1
 • 120 Interviews
View all
Blue Yonder Plsql Developer Salary
based on 25 salaries
₹4.1 L/yr - ₹11 L/yr
16% more than the average Plsql Developer Salary in India
View more details
Senior Software Engineer
364 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Consultant
261 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
232 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Technical Consultant
191 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Consultant
178 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Blue Yonder with

SAP

4.2
Compare

Manhattan Associates

3.7
Compare

Oracle

3.7
Compare

Infor Global Solution

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview