AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Oracle
Compare
Filter interviews by
Oracle Intern Interview Questions, Process, and Tips
Top Oracle Intern Interview Questions and Answers
- Q1. There are 1 million random numbers and 1 number is missing find the missing number
- Q2. Difference between 'having' clause and 'where' clause in MySQL
- Q3. What is Function overloading and overriding?
Oracle Intern Interview Experiences
6 interviews found
Anonymous
I applied via Campus Placement and was interviewed in Jun 2024. There were 3 interview rounds.
It is quite easy.topics like train speed and time , profit loss and work hour energy problems
Coding will be based on DSA .In depth graphs and trees would been asked
(4 Questions)
- Q1. Given a question regarding patterns
- Q2. Explain about os
- Q3. Some SQL commands
- Q4. Explain system calls
Interview Preparation Tips
- DSA
- SQL
A basic dynamic programming question similar to the "pick or not pick" problem.
(1 Question)
- Q1. Dsa questions cs fundamentals resume based questions
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Mar 2023. There were 5 interview rounds.
Basic math problems and English related questions
Write a program to give out the final score in a cricket match where number of deliveries will be the input and in a ball a batsman ca score either 1,0 or 2.
(2 Questions)
- Q1. Write a program to separate strong for special characters
- Ans.
Program to separate strong for special characters in an array of strings
Iterate through each string in the array
For each string, iterate through each character
Check if the character is a special character and separate it into a new string if it is
- Q2. General question about personal projects
(2 Questions)
- Q1. Questions about OOPs concept
- Q2. What is Function overloading and overriding?
- Ans.
Function overloading is having multiple functions with the same name but different parameters. Function overriding is redefining a function in a subclass.
Function overloading allows multiple functions with the same name but different parameters.
Function overriding involves redefining a function in a subclass with the same name and parameters as in the superclass.
Example of function overloading: int add(int a, int b) an...
(1 Question)
- Q1. General question on extra activities in the resume
Skills evaluated in this interview
What people are saying about Oracle
3 questions 1st was dsa 2nd was rest api and 3rd was sql query based on hackerearth ,
(1 Question)
- Q1. Linked list, lis/dp java oops concepts database
Interview Preparation Tips
Oracle interview questions for designations
Interview Questionnaire
3 Questions
- Q1. There are 1 million random numbers and 1 number is missing find the missing number
- Ans.
Find the missing number from 1 million random numbers.
Calculate the sum of all numbers from 1 to 1 million using the formula n(n+1)/2
Calculate the sum of all the given numbers
Subtract the sum of given numbers from the sum of all numbers to get the missing number
- Q2. Algorithm and complexities
- Q3. Basic technical questions
Skills evaluated in this interview
I was interviewed in Feb 2017.
Interview Questionnaire
4 Questions
- Q1. Everything related to previous projects.
- Q2. Normalization of database to BCNF
- Ans.
Normalization to BCNF ensures that every non-trivial functional dependency is satisfied.
Identify all functional dependencies
Eliminate partial dependencies
Eliminate transitive dependencies
Ensure every determinant is a candidate key
- Q3. Difference between 'having' clause and 'where' clause in MySQL
- Ans.
HAVING clause is used with GROUP BY to filter groups, WHERE clause is used to filter rows.
HAVING clause is used with GROUP BY clause to filter groups based on aggregate functions.
WHERE clause is used to filter rows based on conditions.
HAVING clause is used after GROUP BY clause, while WHERE clause is used before GROUP BY clause.
HAVING clause can use aggregate functions, while WHERE clause cannot.
Example: SELECT categor...
- Q4. DBMS queries
Interview Preparation Tips
Experience: It was 1-to-1 interview where I was asked about the previous projects first. They have asked everything about the project, from why we chose the technology we chose and how we implemented it.
Tips: Can't give much tips as I have not faced many interviews myself, but as far as internship interviews go, they require candidates who are willing to learn. You don't need to convince them that you know everything, as the basic understanding of the subject and willingness to learn will do just fine.
Round: Test
Duration: 20 minutes
Total Questions: 25
College Name: PDPM IIITDM, Jabalpur
Skills evaluated in this interview
Interview questions from similar companies
I applied via Recruitment Consultant and was interviewed before Jul 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. DS Algo Questions on Trees. Leadership Principles
Interview Preparation Tips
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
(1 Question)
- Q1. .net questions - routing in asp.net MVC ?
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.
Good
(1 Question)
- Q1. Basic question from C++.Some questions from Data structure and computer architecture.
Interview Preparation Tips
- C++
Interview Preparation Tips
Experience: I had sent my resume to the hiring group, Selection through telephonic interviews. I was interviewed by three different research groups (once by each).
Tips: Factors in decreasing order of importance: CGPA each stage. Ability to explain your projects precisely. Ability to solve ''standard" logarithmic problems. The way you think and put down your Answer is the most important. The final answer .s not so I important, and they prod you when you think out aloud anyway.
Round: Technical Interview
Experience: Almost- by default they ask about your previous projects/internships if they are relevant to the group. Ofher questions depend on the group you are interviewed by and your own profile, In my case it was machine learning, text mining etc. I was told about the research problem they were dealing with then and asked f or comments/suggestions/.inputs and a discussion followed.
Tips: Basically these are specialized Interviews so it's good to have sound knowledge of your domain (analytical and application skills are very much required).
Skill Tips: CGPA>9.0, 1f not (like me) relevant work done in the domain and in past internship.A recommendation from the professor is also a good add on.
College Name: IIT Madras
Oracle Interview FAQs
Tell us how to improve this page.
Oracle Interviews By Designations
- Oracle Software Developer Interview Questions
- Oracle Application Developer Interview Questions
- Oracle Software Engineer Interview Questions
- Oracle Senior Software Engineer Interview Questions
- Oracle Member Technical Staff Interview Questions
- Oracle Applications Engineer Interview Questions
- Oracle Senior Consultant Interview Questions
- Oracle Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Internship Trainee Interview Questions
- Software Developer Intern Interview Questions
- Summer Intern Interview Questions
- HR Intern Interview Questions
- Internal Auditor Interview Questions
- Software Engineer Intern Interview Questions
- Data Science Intern Interview Questions
- Software Development Engineer Intern Interview Questions
- Show more
Oracle Intern Interview Process
based on 3 interviews
Interview experience
Intern Interview Questions from Similar Companies
Fast track your campus placements
Oracle Intern Reviews and Ratings
based on 8 reviews
Rating in categories
|
Senior Software Engineer
2.3k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Consultant
2.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Principal Consultant
2k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Member of Technical Staff
1.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Application Engineer
1.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
SAP
MongoDB
Salesforce
IBM
- Home >
- Interviews >
- Oracle Interview Questions >
- Oracle Intern Interview Questions
