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 for Freshers
Top Oracle Intern Interview Questions and Answers for Freshers
- Q1. Difference between 'having' clause and 'where' clause in MySQL
- Q2. What is Function overloading and overriding?
- Q3. Write a program to separate strong for special characters
Oracle Intern Interview Experiences for Freshers
5 interviews found
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
I appeared for an interview 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
Selected
I applied via Campus Placement and was interviewed before Dec 2021. There were 2 interview rounds.
Basic Aptitude like Quantitative , English and Logical Reasoning. Coding round had 4 questions - 2 SQL problems and 2 codes
(2 Questions)
- Q1. Personality assessment , character judging and seeing if you are fit for the company on the basis of value was checked
- Q2. Tell me about yourself
Interview Preparation Tips
- C++
- SDLC
Software Engineer Interview Questions & Answers
Carelon Global Solutions
Anonymous
posted on 16 Apr 2021
Interview Questionnaire
1 Question
- Q1. Technical questions were asked
Interview Questionnaire
1 Question
- Q1. Computer networking, oops, programming
I applied via Recruitment Consulltant and was interviewed before Oct 2021. There were 4 interview rounds.
(1 Question)
- Q1. Questions regarding mainframe technology
(1 Question)
- Q1. Questions regarding COBOL JCL DB2 SQL VSAM IMSDB
(1 Question)
- Q1. Regarding salary discussion
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Microsoft Corporation
Anonymous
posted on 13 Aug 2021
Interview Questionnaire
1 Question
- Q1. Implement serialization of tree
- Ans.
Serialize a tree data structure
Use pre-order traversal to serialize the tree
Store null values as a special character
Use a delimiter to separate nodes
Example: 1,2,null,null,3,4,null,null,5,null,null
Deserialize by splitting the string and using a queue
Skills evaluated in this interview
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
- HR Intern Interview Questions
- Summer Intern Interview Questions
- Internal Auditor Interview Questions
- Software Engineer Intern Interview Questions
- Data Science Intern Interview Questions
- Data Analyst Intern Interview Questions
- Show more
Oracle Intern Interview Process for Freshers
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.5k
salaries
|  ₹10.3 L/yr - ₹40 L/yr |
|
Principal Consultant
2.1k
salaries
| ₹10.9 L/yr - ₹37 L/yr |
|
Senior Consultant
2.1k
salaries
| ₹9.1 L/yr - ₹25 L/yr |
|
Senior Member of Technical Staff
1.8k
salaries
| ₹13.4 L/yr - ₹45 L/yr |
|
Senior Application Engineer
1.4k
salaries
| ₹9.7 L/yr - ₹30 L/yr |
SAP
MongoDB
Salesforce
IBM
- Home >
- Interviews >
- Oracle Interview Questions >
- Oracle Intern Interview Questions for Fresher
