Upload Button Icon Add office photos
Engaged Employer

i

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

Oracle Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Oracle Site Incharge Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

I applied via Referral and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Why can’t a columns with unique with a not null constraint be used as a primary key?
  • Ans. 

    A unique not null column can be used as a primary key, but not vice versa.

    • Primary key must be unique and not null, but not all unique not null columns need to be primary keys.

    • Primary key is used to identify each row uniquely, while unique not null column is used to ensure data integrity.

    • A table can have multiple unique not null columns, but only one primary key.

  • Answered by AI
  • Q2. Because null can’t be equated
  • Ans. 

    Null cannot be equated as it represents absence of a value.

    • Null is not equal to any value, including itself.

    • Attempting to equate null can result in unexpected behavior.

    • Null is often used to represent the absence of a value or unknown value.

  • Answered by AI
  • Q3. We have 2 procedures with the same names. One with 2 parameters.. second one with 3 parameters. The procedure with 3 parameters has a null also. What will be invoked when we call the procedure
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Approached by Company

Round 1 - Coding Test 

Sort the arr, fetch element from array

Round 2 - Technical 

(2 Questions)

  • Q1. Linklist search
  • Q2. Sort in link List
  • Ans. 

    Sorting in a linked list involves rearranging the elements in ascending or descending order based on a certain criteria.

    • Use a sorting algorithm like bubble sort, selection sort, or merge sort to rearrange the elements in the linked list.

    • Traverse the linked list and compare each element with the next one to determine the order in which they should be sorted.

    • Update the pointers of the nodes in the linked list to reflect ...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Question on trie
  • Q2. Question on intervals
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected

I applied via Approached by Company and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Traverse through a matrix of uppercase english alphabets to find a given word. you are allowed to make up to k jumps, and same position can be repeated too.

Round 2 - Technical 

(1 Question)

  • Q1. Compression of 0-1 matrix of particular size.
  • Ans. 

    Compression of 0-1 matrix involves reducing the size of the matrix by storing only the necessary information.

    • Use run-length encoding to compress the matrix by storing consecutive repeated values as a single value and count.

    • Identify patterns in the matrix that can be represented more efficiently.

    • Consider using sparse matrix representation if the matrix has a lot of zeros.

    • Implement efficient algorithms to compress and de...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
-

I appeared for an interview in Sep 2024.

Round 1 - Coding Test 

C programming and java

Round 2 - Coding Test 

Advanced coding on c

Round 3 - Technical 

(2 Questions)

  • Q1. Why did you choose this company
  • Ans. 

    I chose this company because of its innovative projects, strong company culture, and opportunities for growth.

    • Innovative projects that challenge me and allow me to learn new skills

    • Strong company culture that values teamwork and collaboration

    • Opportunities for growth and advancement within the company

  • Answered by AI
  • Q2. What is your aim
  • Ans. 

    My aim is to continuously improve my technical skills, contribute to innovative projects, and eventually become a technical leader in the field.

    • Continuous learning and skill development

    • Contribution to innovative projects

    • Becoming a technical leader in the field

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(4 Questions)

  • Q1. Fundamental aspects of the healthcare system in the United States
  • Q2. SDLC Process
  • Q3. Experience with Agile methodologies
  • Ans. 

    Experience with Agile methodologies in software development

    • Utilized Scrum framework for project management

    • Participated in daily stand-up meetings to discuss progress and roadblocks

    • Worked in sprints to deliver incremental value to stakeholders

    • Collaborated closely with cross-functional teams to prioritize and deliver features

    • Adapted quickly to changing requirements and feedback

  • Answered by AI
  • Q4. Situation based questions

Interview Preparation Tips

Topics to prepare for Carelon Global Solutions Senior Engineer interview:
  • US Healthcare
  • Agile
  • SDLC

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

Round 1 - Technical 

(1 Question)

  • Q1. Java core microservices

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was very good
Interviewer was knowledgeable

I appeared for an interview 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 appeared for an interview 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

Tell us how to improve this page.

Interview Questions from Similar Companies

Google Interview Questions
4.4
 • 841 Interviews
Amdocs Interview Questions
3.7
 • 517 Interviews
Zoho Interview Questions
4.3
 • 512 Interviews
SAP Interview Questions
4.2
 • 284 Interviews
Adobe Interview Questions
3.9
 • 235 Interviews
Salesforce Interview Questions
4.0
 • 230 Interviews
24/7 Customer Interview Questions
3.5
 • 176 Interviews
View all
Senior Software Engineer
2.4k salaries
unlock blur

₹12 L/yr - ₹40 L/yr

Principal Consultant
2.1k salaries
unlock blur

₹10.9 L/yr - ₹37 L/yr

Senior Consultant
2.1k salaries
unlock blur

₹8.6 L/yr - ₹28 L/yr

Senior Member of Technical Staff
1.8k salaries
unlock blur

₹13.4 L/yr - ₹45 L/yr

Senior Application Engineer
1.4k salaries
unlock blur

₹9.7 L/yr - ₹30 L/yr

Explore more salaries
Compare Oracle with

SAP

4.2
Compare

MongoDB

3.8
Compare

Salesforce

4.0
Compare

IBM

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