Oracle Interview Experience | Applications Engineer

  

Round 1: 

1) Tell me about yourself 

2) Problem Statement:  

Reverse the words in below string considering all negative test cases 



Input: Hello World 

Output: olleH dlroW 
 

  • If the input have more than 1 space as separator then output should contain as much space as input
  • If the statement have start and trailing spaces then output will also contain those spaces
  • Input is case sensitive

3) Sql queries 
 

  • There are 2 tables: Employee and Department.
  • Print the employee name with department name
  • Print the count of employees having same department with department name
  • Print the count of employees having the same department

  

Round 2: 

1) Problem Statement: 

Check if the given string is palindrome or not. If the string is not palindrome then try to make it palindrome if possible 

2) SQL queries: 
 



  • There are 2 tables: Employee and Salary
  • Print only female employees
  • Print the female employee who has highest salary

  

Round 3: 

1) Core java related questions 
 

  • What is method overloading and overriding with example
  • How we can achieve inheritance in java
  • What is default methods in java8 and when should we use it

2) Problem Statement 
 

3) Glass Puzzle 
 

  • My friend was throwing a very grand party and wanted to borrow from me 100 wine glasses. I decided to send them through my boy servant.
  • Just to give an incentive to Servant to deliver the glasses intact I offered him 3 paise for every glass delivered safely and threatened to forfeit 9 paise for every glass he broke.
  • On settlement Harish received Rs 2.40 from me. How many glasses did Harish safely deliver?

  

Round 4: 

1) Puzzle: 
 

  • Using only 1 to 9 numbers, Arrange the numbers such that
  • AxBxC = BxGxE = DxExF
A     D 
B  G  E
C     F
  • Each character should assign distinct numbers

2) Puzzle: 

Using 1 to 16 numbers, sum would be 34 for each column, rows and for both diagonals. Write the program as well to solve the puzzle:



    3  
5     8
9 7   12
  14    

Round 5: 

1) Problem Statement: Merge the sub arrays if possible. Input: List of sub arrays: [1, 10], [11, 15], [13, 25], [30, 40], [40, 50]
Output: [1, 25], [30, 50]

2) Puzzle:

  • There are 101 coins.
  • 1 coin is a faulty coin.
  • A Faulty coin has different weight other than 100 coins. 
  • With a minimum number of comparisons, find that if the faulty coin has higher weight or lower weight than other coins.

Thanks, GeeksforGeeks. It helped me a lot in preparation.


Write your Interview Experience or mail it to contribute@geeksforgeeks.org

My Personal Notes arrow_drop_up

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.