Upload Button Icon Add office photos

e2open

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

e2open Oracle SQL and PLSQL Developer Interview Questions, Process, and Tips

Updated 8 Sep 2024

e2open Oracle SQL and PLSQL Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(5 Questions)

  • Q1. Create table using another table
  • Ans. 

    To create a table using another table, use the CREATE TABLE AS SELECT statement.

    • Use the CREATE TABLE AS SELECT statement to create a new table based on the structure and data of an existing table.

    • Specify the new table name after CREATE TABLE and the existing table name after AS SELECT.

    • You can also add conditions or filters to the SELECT statement to customize the data being copied.

    • Example: CREATE TABLE new_table AS SEL

  • Answered by AI
  • Q2. Check all the joins
  • Ans. 

    The question is asking to identify different types of joins in SQL.

    • Inner Join: Returns rows when there is a match in both tables.

    • Left Join: Returns all rows from the left table and the matched rows from the right table.

    • Right Join: Returns all rows from the right table and the matched rows from the left table.

    • Full Outer Join: Returns rows when there is a match in either table.

    • Cross Join: Returns the Cartesian product of

  • Answered by AI
  • Q3. Index and it's syntax
  • Ans. 

    An index is a database object that improves the speed of data retrieval operations on a table.

    • Indexes can be created on one or more columns of a table.

    • Syntax to create an index: CREATE INDEX index_name ON table_name(column_name);

    • Indexes can be unique or non-unique.

    • Indexes can be used to enforce uniqueness constraints.

    • Indexes can improve query performance by reducing the number of rows that need to be scanned.

  • Answered by AI
  • Q4. Query to fetch highest salary
  • Ans. 

    Use SQL query with MAX function to fetch highest salary from the database.

    • Use SELECT statement with MAX function to retrieve highest salary

    • Specify the column name for salary in the SELECT statement

    • Include the table name in the query if needed

  • Answered by AI
  • Q5. Delete duplicates in the table
  • Ans. 

    Use a DELETE statement with a subquery to remove duplicates in a table.

    • Identify the columns that define duplicates

    • Use a subquery to select the rows to be deleted

    • Use the DELETE statement to remove the duplicates

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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.

I was interviewed in Oct 2016.

Interview Questionnaire 

5 Questions

  • Q1. What is inheritance?
  • Ans. 

    Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.

    • Inheritance allows for code reuse and promotes modularity.

    • The class that is being inherited from is called the superclass or base class.

    • The class that inherits from the superclass is called the subclass or derived class.

    • The subclass can access the public and protected members of the superclass.

    • Inhe...

  • Answered by AI
  • Q2. Regular expressions in PhP
  • Ans. 

    Regular expressions in PHP are powerful tools for pattern matching and manipulating strings.

    • Regular expressions are defined using the preg_match() function in PHP.

    • They are used to search, replace, and validate strings based on specific patterns.

    • Regex patterns consist of a combination of characters and special symbols.

    • Modifiers can be added to the pattern to control the matching behavior.

    • Common regex functions in PHP in...

  • Answered by AI
  • Q3. What is polymorphism? Explain using a real life example
  • Ans. 

    Polymorphism is the ability of an object to take on many forms. It allows objects of different classes to be treated as the same type.

    • Polymorphism allows a single interface to be used for different types of objects.

    • It enables code reusability and flexibility in object-oriented programming.

    • For example, a parent class 'Animal' can have multiple child classes like 'Dog', 'Cat', and 'Bird'. They can all be treated as 'Anim...

  • Answered by AI
  • Q4. Discussion about projects.
  • Q5. Aggregate functions in dbms? And query questions related to that.

Interview Preparation Tips

Round: Test
Experience: 10 questions of aptitude containing English paragraph solving , Maths aptitude and also logical reasoning. Other 3 questions were of programming in any language comfortable.Two of the questions were partially done.In one of them only the logic was to be coded and in the other the error was to be corrected to give the correct output.
Duration: 1 hour 20 minutes
Total Questions: 13

Round: Technical Interview
Experience: They test your basic knowledge of programming, databases and how well you have worked with your projects.
There are actually three more rounds. 2 technical and one HR. I was not selected for them. Out of 40 students only 5 were selected after the final round.

Skills: Basic C/C++, DBMS, Multiple And Multi-level Inheritance, Polymorphism, PHP, Regular Expressions
College Name: Thapar University, Patiala

Skills evaluated in this interview

I was interviewed in Dec 2016.

Interview Questionnaire 

8 Questions

  • Q1. Given a 10 digit number, sort the individual digits of the number.
  • Ans. 

    Sort the individual digits of a 10 digit number.

    • Convert the number to a string to access individual digits

    • Use a sorting algorithm to sort the digits

    • Convert the sorted digits back to a number

  • Answered by AI
  • Q2. Write code for LCA in Binary Search Tree.
  • Ans. 

    The code for finding the Lowest Common Ancestor (LCA) in a Binary Search Tree (BST).

    • Start from the root node and compare it with the given two nodes.

    • If both nodes are smaller than the current node, move to the left subtree.

    • If both nodes are greater than the current node, move to the right subtree.

    • If one node is smaller and the other is greater, then the current node is the LCA.

    • Continue this process until the LCA is fou

  • Answered by AI
  • Q3. Discuss a DBMS consisting of college faculty, professors, courses and students.
  • Ans. 

    A DBMS for managing college faculty, professors, courses, and students.

    • The DBMS should have tables for faculty, professors, courses, and students.

    • Each table should have appropriate attributes to store relevant information.

    • Relationships can be established between tables using foreign keys.

    • Queries can be used to retrieve information about faculty, professors, courses, and students.

    • The DBMS can be used to track enrollment

  • Answered by AI
  • Q4. What extra curricular activities did you do in college?
  • Ans. 

    I was actively involved in coding competitions, hackathons, and programming clubs during college.

    • Participated in coding competitions such as ACM ICPC and Codeforces

    • Attended hackathons to work on real-world projects and improve problem-solving skills

    • Joined programming clubs to collaborate with peers and learn new technologies

  • Answered by AI
  • Q5. Do you seek for help if stuck in a problem?
  • Ans. 

    Yes, I believe in seeking help when stuck in a problem as it leads to faster resolution and learning.

    • I believe in collaborating with team members to brainstorm solutions

    • I am not afraid to ask for help from more experienced developers

    • I utilize online resources like Stack Overflow or documentation when needed

  • Answered by AI
  • Q6. What do you understand by teamwork?
  • Ans. 

    Teamwork is collaborating with others towards a common goal, utilizing each member's strengths and skills.

    • Collaborating with others towards a common goal

    • Utilizing each member's strengths and skills

    • Communicating effectively and openly

    • Respecting and valuing diverse perspectives

    • Sharing responsibilities and supporting each other

    • Celebrating successes as a team

  • Answered by AI
  • Q7. How do you tackle something that you can't find a solution to?
  • Ans. 

    When faced with an unsolvable problem, I break it down, research, seek help, experiment, and iterate until a solution is found.

    • Break down the problem into smaller, manageable parts

    • Research and gather information related to the problem

    • Seek help from colleagues, online communities, or experts

    • Experiment with different approaches or solutions

    • Iterate and refine the solution based on feedback and results

  • Answered by AI
  • Q8. Where do you want to see yourself after 5 years?
  • Ans. 

    In 5 years, I see myself as a senior software developer leading a team of developers on innovative projects.

    • Leading a team of developers on innovative projects

    • Senior software developer role

    • Continuing to learn and grow in the field

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The test had a time limit. Every 10 minutes you had to do atleast 4 questions. It was quite fast paced. The questions were from basic coding, aptitude and debugging.
Tips: Learn to be fast at coding. Study from geeksforgeeks.com. Practice a lot of aptitude questions. Have a decent knowledge of basic coding.
Duration: 1 hour
Total Questions: 20

Round: Technical Interview
Experience: The interviewer started off by asking basic sorting questions. Followed by data structures and algorithms. And DBMS related questions in the end.
Tips: Have a good presence of mind. Understand the question asked properly. Be confident and keep discussing. Don't get nervous and solve the questions incorrectly. Have good grip over topics like sorting, DS, Algorithms and DBMS.

Round: Managerial Interview
Experience: There was a discussion upon the company's work in fields like Big Data, IoT. They asked me in detail about the projects mentioned in my CV. Other skills mentioned in CV were also discussed.
Tips: Have a good understanding of the projects you have mentioned in your CV. Be polite and confident while answering. Keep a general awareness of the current technical scenario.

Round: HR Interview
Experience: The round was based around my over all personality. They checked how would I be an asset to their company. They analysed my core values and capabilities of working in a team.
Tips: Show that you are willing to work in a team. Be confident and polite. Express your feelings and passion towards your job and the company. Explain your college extra curricular activities well.

College Name: IIT Varanasi

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: 1 Psychometric Test
2. Analytical Aptitude
3 Logical Reasoning
4 Two coding Questions
5.Pattern Recognition
6.Essay writing

Tips: Do the coding Question first ,they are mot important ,if ur code doesn't run u are disqualified.
Practice on leetcode
Sectional Cutoff
Duration: 100 mins minutes
Total Questions: 103

Round: Test
Experience: Data base design of an ATM.E-R diagrams ,Class diagram and Normalization
Discussion on projects
A simple coding question
Heavy ball light ball puzzle
Cloud Computing
Public and Private Cloud
CRM ,SRM ,ERP
Asked me Floyd's Warshall Algo,told to implement it in a question
SQL queries





Round: Technical Interview
Experience: 1 asked me a puzzle man and bridge wid torch
2.asked me about TRIES
3.difference between primary key and unique key
4.asked to write query for nth highest salary
5.Asked me as sql injection
6. AES ,DES
7.Reverse a linked list


Round: Behavioural Interview
Experience: The interviewer was above 50.
1.Introduce yourself
2.why sap
3.situation based questions


Round: HR Interview
Experience: The lady was tough ...showed her intent in the PPT as well..
1.asked me about profile preference
2.about family
3.where would you see in next 2 years
4.why sap
5.nything about sap not mentioned in ppt(i was like null)
6.location preference


Skills:
College Name: NIT Srinagar

I applied via Referral

Interview Questionnaire 

3 Questions

  • Q1. Asked on Java, C, Data Structures, Algorithms, Puzzles, Paper Coding
  • Q2. Asked on C, Java, DBMS, Data Structures, Algorithms, Puzzles
  • Q3. This was a managerial round

Interview Preparation Tips

Round: Test
Experience: It had 5 sections. Personality, Design, Coding, Aptitude, Testing. Personality section had 10 minutes and 60 questions. Design section had 15 questions. Coding section had 2 questions. Aptitude section had 15 questions and they were from moderate to hard level. And Testing had 5 questions. The test was really easy but managing time was the game changer.
Tips: Try to spend time efficiently and make good number of attempts in every section. Only Aptitude and Coding sections need separate preparation.
Duration: 105 minutes
Total Questions: 103

Round: Technical Interview
Experience: Interview focuses on basics. The interviewer was supportive.
Tips: Stick do your basics and prepare for them really well. Be attentive.

Round: Technical Interview
Experience: There was no level difference between the first interview and the second, both were of the same level. The interviewer was highly supportive. He was more excited than me when I told the correct answer. He was giving me some hints in between, clinging onto the hints and making out the answers is important. He explained me few things in the interview which I didn't know and then asked me questions on it. Discussion on projects I did also went on for 20 minutes or so.
Tips: Adding on your views to the discussion would always help and show your communication skills also. Don't leave the interview ask a question-answer type of session. Your resume matters. Know about everything you have written in your resume in a depth such that you can build on at least a 10 minute discussion.

Round: Other Interview
Experience: Had a good discussion on the projects I was doing, on the courses I took, my interests and everything that was written in my resume.
Tips: Go with a clear and fresh mind. Show that you are interested in the company and how your interests align with the company.

Round: HR Interview
Experience: Had good and fruitful discussion about everything. My parents, behavior, interests, schooling, college, studies, extra circulars, co-circulars, projects and about the company-we had talked about all these things.
Tips: Just talk your heart out. Don't try to bluff and never ever try to impress. Get the discussion going. Add your views to whatever the hr says. Not for just this round but after every round think of some questions you want to ask the interviewer and have them at the back of your mind. When given the opportunity ask them. Don't ask just for the sake of asking. Everyone has some genuine questions to ask, just think over them and ask them later on.

Skills:
College Name: DA-IICT
Contribute & help others!
anonymous
You can choose to be anonymous

e2open Interview FAQs

How many rounds are there in e2open Oracle SQL and PLSQL Developer interview?
e2open interview process usually has 1 rounds. The most common rounds in the e2open interview process are Technical.
What are the top questions asked in e2open Oracle SQL and PLSQL Developer interview?

Some of the top questions asked at the e2open Oracle SQL and PLSQL Developer interview -

  1. Create table using another ta...read more
  2. Index and it's syn...read more
  3. Query to fetch highest sal...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

ION Group

No Interviews

INTERVIEWS

Cvent

No Interviews

INTERVIEWS

Doppio Group

No Interviews

INTERVIEWS

Cvent

No Interviews

INTERVIEWS

Cvent

No Interviews

INTERVIEWS

Doubtnut

No Interviews

SALARIES

Doppio Group

INTERVIEWS

Cvent

No Interviews

Tell us how to improve this page.

e2open Oracle SQL and PLSQL Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Oracle Interview Questions
3.7
 • 846 Interviews
SAP Interview Questions
4.2
 • 283 Interviews
Globant Interview Questions
3.8
 • 172 Interviews
Chetu Interview Questions
3.3
 • 172 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
AVASOFT Interview Questions
3.6
 • 146 Interviews
ServiceNow Interview Questions
4.1
 • 120 Interviews
Thomson Reuters Interview Questions
4.1
 • 112 Interviews
Amadeus Interview Questions
3.9
 • 107 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