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 within 60 minutes:
- Graph m coloring problem (A slightly modified version of the original question)
- Print a string in a zig-zag format.
Example 1:
Inputs: geeksforgeeks, rowsize = 4
Output: gosefrkesgeke
Explanation: Have to print the alphabets row-wise
g |
|
o |
|
s |
e |
f |
r |
k |
|
e |
s |
g |
e |
|
k |
|
e |
|
|
Example 2:
Input: geeksforgeeks, rowsize = 4
Output: gsgsekfrekeoe
Explanation: Have to print the alphabets row-wise
g |
|
s |
|
g |
|
s |
e |
k |
f |
r |
e |
k |
|
e |
|
o |
|
e |
|
|
Round 3 (Interview Round): The interviews were held over Zoom and consisted of the following rounds:
- Two Technical Interviews (about 1 hour each)
- One HR Interview (about 30 mins)
Some Interview questions:
Both the technical interviewers took 2 minutes to read my resume and then asked questions based on it.
- Introduce yourself (2 times in both tech rounds)
- Rate yourself in the following: C++, Data Structures and SQL
- OOPs/Java questions
-
DBMS questions:
- Query to find the maximum salary from the employee table? (Ans: SELECT MAX(salary) FROM Employee)
- What is the primary key? What is a foreign key?
- What is SQL?
- Difference between TRUNCATE and DELETE command
- What is transaction? I was also asked about the life cycle of a transaction (partially committed, committed, ROLLBACK).
-
Other technical questions:
- I was asked to code the Add two numbers without using arithmetic operators
- I was asked to explain bubble sort in both tech rounds (asked to write pseudocode in second tech round)
- I was asked to explain and write pseudo code for binary search
- He gave me a binary tree structure and asked all three traversals, postorder, preorder, in order. He asked if given preorder, can I tell postorder?
- What is virtual table?
- What is MVC architecture?
-
Resume based questions:
- I was asked to explain each of my projects.
- Some questions mentioned above were also from the resume.
-
Other questions:
- In round 2 I was asked puzzle question.
- I was asked this aptitude question, the distance between A and B is 100 km. One person starts from city A at 50 kmph and another starts from B at 40 kmph. At what point will they meet?
Final result: Selected
Last Updated :
01 Sep, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...