Wilford  Pagac

Wilford Pagac

1603677600

Oracle Interview Experience | Full Time for Server Technology (On-Campus)

1st round: MCQ Test Round(online)

The test was divided into four sections:

(i) Aptitude:

Mathematics(probability, equation based),

Reasoning(basic puzzles),

Observation(You just had to tell which of the 4 options was present in the above given 10×3 table just by looking and observing),

Flowchart(a flowchart for a given situation was given, and some conditions(standard diamond shaped boxes) were empty. You had to tell which option fits which of the conditional boxes. There were 3,4 questions on the same flowchart, so properly studying the chart could help you answer all the associated questions).

(ii) Coding Output Based:

Most questions were based on predicting output of the given code snippet( There were a lot of questions from Trees(any sub-topic)),

Some complexity based questions.

(iii) Core Subjects:

Fundamental(most) and tricky(few) questions from OS, DBMS, OOPS.

(iv) English Comprehension:

Unseen passage based questions,

Grammar based questions,

Ordering the sentences in a meaningful order,

best synonym substitution based questions.

A lot of practice is needed to solve this section. You have to maintain your speed throughout the test.

2nd Round: Coding Round

1. https://www.geeksforgeeks.org/count-triplets-such-that-sum-of-any-two-number-is-equal-to-third-set-2/

2. https://www.geeksforgeeks.org/segregate-even-and-odd-elements-in-a-linked-list/

They will ask you for your preferable language for coding. You can choose any language with which you are comfortable.

You have to write the whole code from inputting to printing output. They will provide you the link of coderpad and then you have to code there. They will run the code when you are done with it.

3rd Round: Technical Round

The questions started from OOP concepts:

(i) Constructors and Destructors

(ii) Purpose of Destructors

(iii) Why Destructor is used when delete is there?

(iv) Operator Overloading

After this he asked my favorite subject to which I replied Databases. Then a series of questions were asked from this.

(i) Normalization

(ii) ACID properties

Since I am master’s student they asked me what new I can think to apply in Databases.

They gave me a hypothetical situation that I am an Oracle employee working on cloud and he is the client. How can I keep his data safe in case of some failure?

To this I answered, we can keep user’s data at different places so that when failure occurs loss is minimal. Or we can create replication of data and keep it at some other place.

4th Round: Technical Round

The interviewer started with clouds, if I knew anything about it.

I simply said No, I never worked on it.

He asked if I can think of any method where I can reduce computational complexity.

I answered in context of my project where I ran a deep learning pre-trained model on my laptop by creating bottleneck features.

He was a bit impressed with my project. He asked the datasets which I used and the accuracy.

Next he said he wanted something in terms of system design so he asked to imagine a situation where I have to make robot drive a car. How will I do it?

I told we can apply object detection to find the objects and also a moving hardware so that robot can drive itself. It should have a software for traffic rules and also should have a camera to recognize objects.

#interview experiences #marketing #on-campus #oracle

What is GEEK

Buddha Community

Oracle Interview Experience | Full Time for Server Technology (On-Campus)
Wilford  Pagac

Wilford Pagac

1603677600

Oracle Interview Experience | Full Time for Server Technology (On-Campus)

1st round: MCQ Test Round(online)

The test was divided into four sections:

(i) Aptitude:

Mathematics(probability, equation based),

Reasoning(basic puzzles),

Observation(You just had to tell which of the 4 options was present in the above given 10×3 table just by looking and observing),

Flowchart(a flowchart for a given situation was given, and some conditions(standard diamond shaped boxes) were empty. You had to tell which option fits which of the conditional boxes. There were 3,4 questions on the same flowchart, so properly studying the chart could help you answer all the associated questions).

(ii) Coding Output Based:

Most questions were based on predicting output of the given code snippet( There were a lot of questions from Trees(any sub-topic)),

Some complexity based questions.

(iii) Core Subjects:

Fundamental(most) and tricky(few) questions from OS, DBMS, OOPS.

(iv) English Comprehension:

Unseen passage based questions,

Grammar based questions,

Ordering the sentences in a meaningful order,

best synonym substitution based questions.

A lot of practice is needed to solve this section. You have to maintain your speed throughout the test.

2nd Round: Coding Round

1. https://www.geeksforgeeks.org/count-triplets-such-that-sum-of-any-two-number-is-equal-to-third-set-2/

2. https://www.geeksforgeeks.org/segregate-even-and-odd-elements-in-a-linked-list/

They will ask you for your preferable language for coding. You can choose any language with which you are comfortable.

You have to write the whole code from inputting to printing output. They will provide you the link of coderpad and then you have to code there. They will run the code when you are done with it.

3rd Round: Technical Round

The questions started from OOP concepts:

(i) Constructors and Destructors

(ii) Purpose of Destructors

(iii) Why Destructor is used when delete is there?

(iv) Operator Overloading

After this he asked my favorite subject to which I replied Databases. Then a series of questions were asked from this.

(i) Normalization

(ii) ACID properties

Since I am master’s student they asked me what new I can think to apply in Databases.

They gave me a hypothetical situation that I am an Oracle employee working on cloud and he is the client. How can I keep his data safe in case of some failure?

To this I answered, we can keep user’s data at different places so that when failure occurs loss is minimal. Or we can create replication of data and keep it at some other place.

4th Round: Technical Round

The interviewer started with clouds, if I knew anything about it.

I simply said No, I never worked on it.

He asked if I can think of any method where I can reduce computational complexity.

I answered in context of my project where I ran a deep learning pre-trained model on my laptop by creating bottleneck features.

He was a bit impressed with my project. He asked the datasets which I used and the accuracy.

Next he said he wanted something in terms of system design so he asked to imagine a situation where I have to make robot drive a car. How will I do it?

I told we can apply object detection to find the objects and also a moving hardware so that robot can drive itself. It should have a software for traffic rules and also should have a camera to recognize objects.

#interview experiences #marketing #on-campus #oracle

Wilford  Pagac

Wilford Pagac

1603699200

Oracle Interview Experience | Server Technology Role Full Time (On-Campus Sept 2020)

Oracle came to our campus in Sept 2020, for a server technology profile. All rounds were audio and video proctored. The entire 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 – It was an online test consisting of four sections. Each of these sections had a different time limit. One must be very quick and efficient to solve all these questions. The overall difficulty was medium.

Section 1. Aptitude – It had questions based on: Basic Arithmetic Aptitude, Logical Reasoning, Data Interpretation, Patterns.

Section 2. Language – It had questions based on: Comprehension, Sentence reordering, Grammatical error, Synonyms & Antonyms.

Section 3. Coding MCQ – It had questions based on: Code snippet, identify the output or error, time complexity. (most of them was on trees, graph, and searching techniques)

Section 4. Computer Science Subjects – It had questions based on: DBMS, Data Structures, OS, OOD

Round 2 – technical interview round 1

1. Started with asking about some questions on C like what are register and auto, the difference between malloc and calloc.

2. Program to find out the process id and parent process id.

3. Questions on OOP concepts.

4. What is synchronization, why do we need synchronization. Write a program(in any language) where some threads are trying to read a common buffer and some are trying to write it. Now if the buffer is empty the read threads should be blocked until a write thread writes something and the write threads are blocked if the buffer is full until a read thread reads(delete) a character from the buffer.

5. Now the interviewer asked about my favorite data-structure(I said tree). Then he asked to write a program to build BST given preorder. And then write a function to check if it is balanced and BST using constant space.

Round 3 – technical interview round 2

1. Explain the concept of paging.

2. Explain the concept of virtual memory.

3. What is thrashing?

4. Given an almost sorted array sort it efficiently https://www.geeksforgeeks.org/nearly-sorted-algorithm/.

5. Given an array {1,2,3,1,2,1,5,6} find the smallest number occurring at least k number of times. Expected time and space O(n). Here for k=2 output is 1.

Round 4 – technical interview round 3

1. What is multithreading and multiprocessing? When to use multithreading/multiprocessing?

2. Consider a college example where admins trying to modify grades of students and students trying to read their info. Now how to synchronize so that no student reads the wrong info and where to use multithreading/multiprocessing here?

3. How are the tables stored in the database to provide fast search/read operations?

4. Given the rate of electricity for the different range of unit consumption. Now given a consumption, find the cost of it.

#interview experiences #marketing #on-campus #oracle

Wilford  Pagac

Wilford Pagac

1603699200

Oracle Interview Experience for Server Technology Full Time Role

Oracle

Oracle visited our campus for virtual hiring for two roles –

  • Server Technology Role and Application Engineer Role.
  • Around 500 students appeared for the online test.

Online test(107 mins):

  • Firstly they conducted an online test on their own platform which was proctored (Camera and Mic).
  • The test consisted of many sections and each section has subsections that had a fixed amount of time for attempting.
  • Aptitude, DSA Concepts(mainly trie, AVL, binary search tree), CS subjects theory from OS, DBMS, OOP’s, Software Engineering. And some English based aptitude and reasoning.

Around 90 students were shortlisted. I was selected for the interview of server technology.

Due to this pandemic, the interviews were held on the Zoom platform.

Technical Interview 1 (55 minutes):

  1. Tell me about yourself? Firstly the interviewer introduced himself.
  2. He asked me some questions related to my resume like about chess, how did you spend your time in the lockdown, where are you from and what do you like about that place.
  3. Now he asked me what all data structures I knew?
  4. He asked me to code Djikstra Algorithm on CoderPad https://www.geeksforgeeks.org/dijkstras-shortest-path-algorithm-greedy-algo-7/
  5. Then he said that he will be asking me some questions based on DSA. He wanted me to answer the most optimized approach that I knew.
  • Stack vs Queue? Binary Tree? Binary Search Tree? Graphs?
  • Reverse a Linked List? (Approach only)
  • Find the cycle in Linked list? (Approach only)
  • How to implement stack using a linked list? (Approach only)
  • Lowest Common Ancestor in a Binary Search Tree? (Approach only)
  • Find the smallest element in a rotated sorted array? (Since I Fumbled in explaining verbally, he wanted me to code this at the end. ( On CoderPad)
  • Explain all oop’s concept with examples – Inheritance, Aggregation, Abstraction, Overriding, Overloading, Encapsulation.
  • ACID property? Transaction? Paging?
  • How will prevent data loss due to some natural calamity?
  1. He then asked me to brief about my projects!

Around 40 students were eliminated after this round out of the 90.

Technical Interview 2 (40 minutes):

  1. Top View of the tree (To code)
  1. Validate Binary Search Tree? https://www.geeksforgeeks.org/a-program-to-check-if-a-binary-tree-is-bst-or-not/ (To code)
  2. What are the things I know in Computer Networks? and asked some questions?
  3. NAT? https://www.geeksforgeeks.org/network-address-translation-nat/
  4. What are the things that happen when you click www.google.com on your browser!
  1. What is normalization? 3NF? https://www.geeksforgeeks.org/normal-forms-in-dbms/
  2. He then asked me two puzzles- I was able to solve one of them only.
  3. https://www.geeksforgeeks.org/puzzle-8-balls-problem/
  4. https://www.geeksforgeeks.org/puzzle-16-100-doors/
  5. Then I asked him two questions
  6. What is the difference between Server technology and Application Engineer?
  7. What kept you here at Oracle?

Technical Interview 3 (40 minutes):

  1. Evaluate Postfix expression https://www.geeksforgeeks.org/stack-set-4-evaluation-postfix-expression/ (To Code)
  2. Evaluate Polynomial Expression https://www.geeksforgeeks.org/adding-two-polynomials-using-linked-list/ (Approach only)
  3. Multiply ‘x’ with ’17’ without using ‘*’ https://www.geeksforgeeks.org/multiply-a-number-by-15-without-using-and-operators/ (Approach only)
  4. https://www.geeksforgeeks.org/in-a-linked-list-given-only-a-pointer-to-a-node-to-be-deleted-in-a-singly-linked-list-how-do-you-delete-it/ (Approach only)
  5. Java VS Python VS C++ VS C
  6. Virtual Function and Operator overloading
  7. He asked about my day to day life in college and how it changed after the lockdown!

I asked him a question since he was a senior technical member of the company~ What kept you here at Oracle for 15 years?

Around 30 students, gave their 4th round and some were selected after the 3rd round only.

#interview experiences #marketing #on-campus #oracle

Wilford  Pagac

Wilford Pagac

1603656000

Oracle Interview Experience for Server technology | On-Campus 2020

Oracle visited my campus for Server Technology Role recently. Selection process involved total of 4 rounds. 1 Written + 3 Interview Rounds.

Written Round:

Written round was an online MCQ round for 107 minutes. Exam was mainly divided into 5 sections:

• Aptitude

• Computer Science Knowledge

• Coding skills

• Language

Each section had a different time limit. Each section was further divided into many subsections and those subsections could be attempted in any order. The time limit of each such subsection summed up to decide the time limit for the section.

Aptitude section contained questions from arithmetic’s, logical & verbal reasoning.

Computer Science Knowledge section had some questions from OS(intermediate level), DBMS(intermediate to advanced level) and OOD.

Coding skills section contained a subsection of code snippets in which we had to predict the output or choose the right code snippet which shall go into the blank space given in questions and sub-section of flow-chart where a problem was defined first in words then through a flow chart. Some boxes of flowchart were blank and we had to choose the right option which would go into blank boxes.

Language sections had questions like unseen passages, arranging sentences in the right order, pointing out the errors in given sentences and few questions on antonyms & synonyms.

This round required a sharp presence of mind and fast speed because each section was timed and questions were more in number hence you need to solve them as fast as we can.

Interview Round 1:

This was more of a theoretical and OOPS based round. Interviewer started with my introduction. Then he quickly moved on to oops:

• What are some features of C++ you like(I had mentioned C++ in my resume)?

I told him about object-oriented programming, program reusability, Encapsulation, Abstraction and Polymorphism. He was satisfied and asked me to stop there.

• How many types of polymorphism are there?

I explained static and dynamic polymorphism.

• What is abstract class? How is it made? What is the purpose of abstract classes?

I enunciated all of it with an example of area class being inherited by rectangle and triangle class. I also explained about virtual keyword and pure virtual functions.

• What is interface? How it is different from abstract class?

• If we define a function with the same name and same number of parameters in derived class as in base class(function is a virtual function in base class) but we change the type of parameter, will it still be method overriding?

#interview experiences #marketing #on-campus #oracle

Wilford  Pagac

Wilford Pagac

1603670400

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 section had a different time limit. One has to be quick and efficient to solve all the questions. The overall difficulty was medium.

1. Aptitude – Basic Arithmetic Aptitude, Logical Reasoning, Data Interpretation, Patterns.

2. Language – Comprehension, Sentence reordering, Grammatical error, Synonyms & Antonyms.

3. Coding MCQ – Code snippet, identify the output or error, time complexity. (most of them was on trees, graph, and searching techniques)

4. Computer Science Subjects – DBMS, Data Structures, OS, OOD

Out of 127 students, 46 students shortlisted for technical interview rounds.

Round 2 – technical interview round 1

The interviewer started with the basic introduction. Then he had a glance over the resume, as I have mentioned data structure as one of my skills, so he started with questions on Data Structures.

– What is a Binary Search Tree, Explain?

– What is Balanced Tree, Skewed Tree, and Complete Tree?

– How to insert, delete, and search an element in a binary search tree and explain each operation’s average and worst time complexity?

– How to insert an element in the array (assume the number of elements is less than the array’s fixed size) also state the time complexity?

– What is Polymorphism, runtime, and compile-time Polymorphism, explain with an example?

– What is a virtual function, explain working and implementation, and why they are used (he went deeper into function overriding )

– What is recursion, write code for Fibonacci both recursively and iteratively?

– Why recursion is used over the iterative approach? What if the base condition or termination condition is wrong, which type of error gets generated (long discussion on how recursion internally uses Stack), memory.

– Can you calculate the size of the memory using recursion?

– Give an elementary example to create an infinite loop. (Ans. while True: )

– Explain and code on the notepad to detect a loop in a linked list.

– What are the vectors in C++? Have you heard STL in C++?

– What is malloc(), calloc(), and free() functions, write syntax, and explain how they work?

– Puzzle: What is the angle between the minute hand and an hour hand when the time is 10:20 AM.

Round 3 – Technical interview round 2

This round was a coding round on a shared coderpad. Before solving, she asked what lockdown did bring change and what skills I worked on during lockdown.

1. There are N balls in a bag, and every ball has a number on it. Print the number where the sum of similar balls is equal to target = 20. (use any language of choice)

For e.g. input: [5,20,5,11,8,5,5,3,1]

output: 5

20

(Talk and ask how input and output would be like, explain what you understood before start coding)

2. Give a real-life example of Stack.

3. Implement Queue from scratch such that can be imported or use in the different programs.

4. Explain Principles of Object-Oriented Programming.

Round 4 – Technical interview round 3

#interview experiences #marketing #on-campus #oracle