Open In App

Oracle Interview Experience | Campus Placements 2020

Last Updated : 01 Sep, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

Online Test (150 mins): This round had certain sections. There was an additional constraint that in each section, one had to answer the questions in order. A candidate could not skip questions and re-attempt them later. The sections were based on the following:

  1. Aptitude
  2. DSA concepts
  3. CS courses concepts such as OS, DBMS, OOP
  4. English

Around 200 students appeared for the online test from which approximately 65 were selected for the technical interviews. 

Technical Interview 1: Due to coronavirus lockdown, the interviews were held on Zoom. 

  1. Explain Multithreading 
  2. Advantages/Disadvantages of Multithreaded vs. Single Process programs.

    Answer: Multithreaded – Can exploit the parallelism of a task and achieve a speedup. Also, the program can be logically divided into many threads which can then be developed individually. It will also make efficient use of memory and CPU time. However, multithreaded programs are harder to debug, and harder to write. 

    Single Process programs – Entire program has to be loaded at once, even though it has multiple components some of which will be used seldom. Thus, it leads to a waste of RAM. However, they are much easier to debug.

  3. What will happen if a thread dies?

    Answer: The master process must monitor the status of each thread and take appropriate action – abort the program, restart a thread.

  4. Given an array, for every index, compute the product of all elements of the array except the element at that index. Using the division operator is NOT ALLOWED.

    Answer: Maintain a prefix and suffix product array and calculate accordingly

  5. Puzzle question: When a man goes to a temple, he gives half of the flowers he has to the gatekeeper and 100 flowers to the gods. In this manner, after visiting 3 temples, he’s left with 0 flowers. How many flowers did he have to begin with?&

    Answer:

    f(f(f(N))) = 0, find N where f(N) = N/2 - 100 

Technical Interview 2:

  1. Explain heap and the various types of heaps
  2. Which data structure is convenient for performing BFS

    Answer: Queue.

  3. What are the possible implementations of a queue and which one would you prefer?

    Answer: Linked List and Array. I would prefer Linked List as array offers constant time random access which is not required. Array resizing would create overheads on insertions

  4. I was given an SQL query involving two tables which had to solved using LEFT JOIN
  5. Given an array of unique elements, design a function that will return a unique sequence of all its elements every time it is called&.

    Answer: Start with sorted order. The desired function would be the nextPermutation() function.

  6. Puzzle question: There is a book whose pages are numbered from 1-150. How many digits are used in enumerating all the pages?

Technical Interview 3:

  1. What is the best and worst-case time complexity of quicksort?
  2. For what type of input does the worst-case time complexity of quicksort occur?

    Answer: For input array in ascending or descending order

  3. Describe the phases of a compiler.
  4. Generate all Parenthesis – II from. The problem is Print all combinations of balanced parentheses

  5. Find the maximum subarray sum and also report the indices of the subarray

HR Round: This round was fairly straightforward. I was asked to talk about my technical interests, hobbies, and whether I was willing to relocate 

Verdict: Selected for the role of Server Technology Engineer.

Tips:

  1. Be calm and composed
  2. Be thorough with your CS subjects
  3. For puzzle questions, write down precise mathematical steps to make solving them easier
  4. Speak eloquently in the HR round

Similar Reads

Oracle Interview Experience | Set 20 (On-Campus for Oracle Financial Services Software)
OFSS visited our campus for recruiting associate application developer . There were 3 rounds in all 1) online test 2) technical interview 3) HR interview 1) Online Test The test broadly consisted of 4 sections - Coding outputs (mainly trees, AVL trees) - English (Grammar,RC) - Computer Science subjects (DBMS,OS,DS) - Aptitude The test lasted for 2
1 min read
Oracle Interview Experience | Set 22 (On-Campus for Oracle Financial Services Software)
Written round: There were questions related to quantitative,logical and verbal.(Not of very high level,but speed should be good enough). Technical PI: 1. C:Basic topics of C.Malloc and Clloc difference.Storage classes.Let us C is enough . 2. C++/Java: OOPs concept with real life examples,Collection in Java,Constructors etc . Site i referred: JAVATP
1 min read
Placements (On-Campus, Off-Campus and Pool Campus)
First of all, you can't compare Campus Placements with off-campus placements. Both of them all good in there in own ways. Let's discuss both of them one by one. ON CAMPUS PLACEMENTS Let's start discussing ON campus placements first, If you are a college student you must be aware of campus placements, You must have heard "Placements Drives Are Going
4 min read
Oracle Interview Experience For Oracle Application Labs 2024
Recently, I had the opportunity to interview face-to-face at Oracle Pune for a role at Oracle Application Labs. As a fresher with around 1 year of experience, I was eager to showcase my skills and enthusiasm for the position. Despite not clearing this round, I believe my experience could be helpful to others, hence, I decided to share it. Introduct
2 min read
Oracle Interview Experience | Virtual On-Campus 2020
Round 1: This round consisted of questions from Aptitude:- Logical Reasoning | Data Interpretation | Analytical thinking | Arithmetic AptitudeSoftware Cs subjects: DBMS | OOD | OSCoding Round (MCQ): TREES ( Mainly AVL) | Linked List | QueuesEnglish: Basic grammar and spell check This round will be moderate to hard. There is no way malpractice is do
2 min read
Oracle GBU Interview Experience | Campus Placement Drive 2020 -Virtual process
Round 1: Round 1 was an online MCQ round consisting of aptitude, verbals, reasoning, and technical questions. The round was divided into many sections with a separate time frame for each section. The total time, including all sections, was 107 minutes. Round 2: Round 2 was an online coding round, in which we were given two coding questions to solve
3 min read
Oracle Interview Experience for Server Technologist | On-Campus 2020 (Virtual)
College: Cummins College of Engineering for Women, Pune Branch: Electronics and Telecommunication Round 1: This round consisted of a camera and audio proctored test with the level of questions from moderate to hard. Aptitude: Logical Reasoning/Data Interpretation /Analytical thinking/Arithmetic AptitudeSoftware CS Subjects: DBMS/OS/OODCoding Round
2 min read
Oracle Interview Experience | On-Campus 2020
Oracle visited our campus for two profiles OFSS and OFGBU. First round: It was a technical and aptitude test conducted on Oracle's own platform. It was 2 hours test consisting of two sections. Qualitative, quantitative, and verbal ability questions. Each section had a time slot. Computer fundamental consisting of questions from flow charts, DSA, co
2 min read
Oracle Interview Experience (Server Technology) | On-Campus 2020 (Virtual)
Oracle came to our campus for a server technology profile. Round 1 was an online test, audio and video proctored. The whole interview process was on zoom meetings. It was a very smooth virtual experience; there were counter rooms inside zoom meetings for post and pre-interview sessions. Round 1 was an online test consisting of four sections. Every
4 min read
Oracle MTS Interview Experience for Server Technology | On-Campus 2020
Online Round: This round was held on Oracle's own platform and consisted of many sections such as. Mathematics and Logical reasoningVerbal ability and comprehensionCS fundamentalsDS/Algo(flow chart completion, function-related, etc) All the sections had fixed timing and students can't revisit any questions. The time allotted was 107 min and had alm
3 min read
Practice Tags :