Upload Button Icon Add office photos

e2open

Compare button icon Compare button icon Compare

Filter interviews by

e2open Plsql Developer Interview Questions and Answers

Updated 6 Oct 2022

e2open Plsql Developer Interview Experiences

1 interview found

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 questions from similar companies

I applied via Recruitment Consultant and was interviewed in Apr 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Real time example for normalization
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization helps to eliminate data redundancy and inconsistencies

    • It ensures that each piece of data is stored in only one place

    • It reduces the chances of data anomalies and inconsistencies

    • Normalization is achieved through a series of steps called normal forms

    • Examples of normalization include breaking down a c...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well in plsql as well as mysql

Plsql Developer Interview Questions & Answers

Blue Yonder 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 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

I was interviewed in Mar 2017.

Interview Questionnaire 

3 Questions

  • Q1. Your projects/courses/past experiences
  • Ans. 

    I have worked on various projects during my time in university, including a web development project and a mobile app project.

    • Developed a web application using HTML, CSS, and JavaScript for a school project

    • Created a mobile app using React Native for a personal project

    • Completed courses in data structures and algorithms, as well as software engineering principles

  • Answered by AI
  • Q2. Why do you want to join MA?
  • Ans. 

    I want to join MA because of its reputation for cutting-edge technology and collaborative work environment.

    • MA is known for its innovative projects and use of advanced technology.

    • I am impressed by the collaborative work culture at MA.

    • I believe joining MA will provide me with opportunities for professional growth and development.

  • Answered by AI
  • Q3. What do you hope to gain from this internship?
  • Ans. 

    I hope to gain practical experience in software development, expand my skills, and learn from experienced professionals.

    • Gain practical experience in software development

    • Expand my skills in coding and problem-solving

    • Learn from experienced professionals in the field

  • Answered by AI

Interview Preparation Tips

Round: HR Interview
Experience: This was simply an overall background of my experience in Computer Progranming, nothing intimidating.

Round: Behavioural Interview
Experience: This round was with my supervisor. Here I asked a lot of questions about the work environment, what I'd be working with, technologies involved, etc.
Tips: Ask relevant questions, and show how eager you are for the job. I even sent an email later on to my supervisor for more details, so I could learn the technology in advance. This he told me later, was why he hired me.

College Name: Georgia Institute of Technology

Interview Preparation Tips

Round: Test
Experience: Oracle had an online test which includes 3
Sections:
1. Programming: basic C++/java programming + data structure. One need to have good hand over oops
to score well in this section.

2. Aptitude: General Aptitude Questions

3. General Maths: Very simple maths problem (+2 level) but needs very very good speed.
Tips: Individual cutoff was not declared, but different cutoff for different profile is expected.
Oracle has no GD round.

Round: Interview
Experience: In 2nd round of interview, there was more programming, less resume based question and more emphasis on will I be comfortable in an IT sector. Some apti questions were also asked.

Round: Interview
Experience: 1st round was completely on resume based. Each and every project and intern is discussed in detail. Most of the extracurricular activities were also discussed. In the 1st interview, some basic program like fibonacci series by recursion, star pattern by loop etc were asked.

Round: Interview
Experience: Next round was HR. I was asked about the earlier 2 interviews and some basic HR questions.

College Name: IIT Roorkee

Interview Preparation Tips

Round: Test
Experience: The sections were Quantitative, Logical, Verbal and Computer Science.The three sections contained very basic questions of general aptitude while the Computer Science section contained questions on Database Management, OS, SQL and Programming Aptitude.

Round: Test
Experience: The question was to program a logic to test the correctness of a solved sudoku. We were allowed to code in C++, Java, C or pseudo code.

Round: Technical Interview
Experience: Were asked simple questions and program them like reversing string without temporary variables, finding the earlier date when entered as string and finding the difference in number of days between them.
I was asked to explain him my internship project in great detail and above all one should be prepared to answer the question 'Why IT?' if from a non IT background. Then I was asked to program a logic for 'Search and replace" tool of MS Word.

Round: HR Interview
Experience: Was asked about my background in detail and stressed again and again on 'Why IT?'. Then he asked me to prepare a summary on the merits and demerits of various Employee Data Management techniques for an organisation. For the end of the interview you should have a question which you would ask to the interviewer.

General Tips: Don't try to over emphasize the correctness of your logic if the interviewer finds a glitch. It irritates him. Be interactive in your HR round. In our case it was the VP of Oracle India who took the final round. So I asked him about his experience in the company. He was very happy to share it with me. But asses your interviewer before you put forth these queries cause your interviewer might not be as jolly as mine was.
Skills:
College Name: NIT Surathkal

Interview Preparation Tips

Round: Resume Shortlist
Tips: If you think it is worth it, write it in the resume.

Round: Technical Interview
Experience: I discussed a political party in one such interview in another company. He was impressed rather inspired.
Tips: All they are looking for in this interview is that you have a basic aptitude

Round: HR Interview
Tips: Try to be as real as possible. They know people and have great deal of experience. You cannot fake it.

General Tips: Peace yoo
College Name: IIT BOMBAY

Interview Questionnaire 

2 Questions

  • Q1. Ques on SQL,puzzles, C
  • Q2. Basic family background, hobbies, academics, why interest in software field, questions from the ppt they presentec earlier

Interview Preparation Tips

Round: Test
Experience: apti and logical reasoning ques  were not tough and with basic knowledge on C and SQL I could easily solve the questions
Tips: Just try to  maintain a good speed while solving

Round: Technical Interview
Experience: mostly they focus their questions based on the form that we had to fill. it had details about our extracurricular activities, main courses of interest, training and project work, software languages known, academics.
Tips: the form was to be filled with accuracy and only those points about which one is confident enough should be added

Round: HR Interview
Experience: it was just a normal interaction. they wanted to know the kind of person i am, my strengths and weakness. any impressive qualities unique of me. my favourite author. it lasted no longer than 10 minutes . and try to acquire as much background information as you about the company.
Tips: try to be honest with your answers. do not fake since they can easily catch you. do not give any such answers about which you are not confident or any view where you cannot defend yourself.

Skill Tips: I learned sql from w3school.com.
Skills: confidence, amicable nature, leadership qualities, participation in extracurricular activities, puzzle solving, Aptitude
College Name: NIT ROURKELA
Motivation: Its quite simple, I wanted to land with good job before i leave  nit.
Funny Moments: Since it was the first time i was facing an interview, so i asked my interviewer how were my answers.

e2open Interview FAQs

How many rounds are there in e2open Plsql Developer interview?
e2open interview process usually has 2 rounds. The most common rounds in the e2open interview process are Resume Shortlist and One-on-one Round.
How to prepare for e2open Plsql Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at e2open. The most common topics and skills that interviewers at e2open expect are PLSQL, Data Analysis, Demand Planning, ETL and Oracle.
What are the top questions asked in e2open Plsql Developer interview?

Some of the top questions asked at the e2open Plsql Developer interview -

  1. Delete duplicate records from ta...read more
  2. Some questions of database like types of joins, second highest salary from empl...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Oracle Interview Questions
3.7
 • 851 Interviews
SAP Interview Questions
4.2
 • 283 Interviews
Chetu Interview Questions
3.3
 • 173 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
AVASOFT Interview Questions
3.6
 • 157 Interviews
ServiceNow Interview Questions
4.1
 • 120 Interviews
Thomson Reuters Interview Questions
4.1
 • 112 Interviews
Amadeus Interview Questions
3.9
 • 107 Interviews
EbixCash Limited Interview Questions
4.0
 • 102 Interviews
View all
Software Engineer
166 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
145 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
134 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
110 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
91 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare e2open with

Blue Yonder

3.9
Compare

Manhattan Associates

3.7
Compare

SAP

4.2
Compare

Oracle

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