Open In App

Oracle Interview Experience for Member of technical staff

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

Oracle had come to our college on 21/08/2020. It had offered 2 roles- Application development and Server technology. The first round was an online test which was very extensive. It had the following sections

  1. Aptitude, Logical Reasoning (tough)
  2. Coding MCQ(medium): All the questions were based on Binary trees, Binary Search Trees and AVL Trees
  3. Technical MCQ(medium): Questions were based on DBMS, OS, CN
  4. Verbal Ability(easy)

The main constraint was time. It was very important to have accuracy along with speed. Based on the first round, they had segregated us into Server technology and Applications Engineer.

I was shortlisted for the Server Technology Role

Technical Interview 1: I was asked about what I had done recently. I explained to the interviewer about the Cloud course that I had done. He asked me a few questions about one of my projects which were on networking. As he also had been working on a similar product as the project mentioned in my resume, he asked me a few questions about cipher keys, a man in the middle attack, and some basic security concepts I knew about. He asked this coding question:

Print the string after removing all its duplicates. (It was supposed to be case-insensitive, i.e. K and k meant the same)

Technical Interview 2: I was asked to elaborate on my internship project. I was asked some questions on networking such as the difference between GET and POST, port numbers of some important ports. Next, I was asked this coding question:

  1. Find Second largest element in an array
  2. Puzzle: Puzzle | Set 35 (2 Eggs and 100 Floors)

Technical Interview 3: The interviewer asked me how good I was at DBMS. Then she asked me the following queries:

If you are given Employee and Department tables, how will you find out the name of the department which has 0 employees? 

What is a view? What happens when I want to insert into a view? Does it get reflected in the actual table? What are the conditions under which the changes will be reflected?

Explain the type of Joins

She asked me to explain the project which was mentioned in my resume, in which I used DBMS and Java. She asked me to write some complex queries written in my project. She asked me to explain the ER diagram, the relations I used.

The interviewer then asked me about any queries I had. 

Result: I was selected for the Server Technology role

I would like to extend my heartfelt gratitude towards GeeksforGeeks. I would not have been able to answer the questions, especially in the Technical Interview 2 round, without their collection of archives. 

My advice to all the upcoming students would be to go through all the archives of the company. Practice aptitude in a timed method in order to be able to develop accuracy. Know everything mentioned in your resume. Be very thorough with OOPs, OS, DBMS irrespective of what your specialization is in.

Thank you


Similar Reads

Oracle Interview Experience | Set 25 (Senior member in Technical Staff for 2+ Experienced)
Round 1: Unix Java SQL questions of basic knowledge. Previous projects :moderate 1. Questions on Java : manipulation, string 2. Hashing 3. Unix commands 4. Previous projects: whats the achievement, how much difficulty level is there 5. Sql queries: 2nd highest salary person and commands. 45 min Round 2:Oracle Products and in depth knowledge. : diff
1 min read
Oracle Apps Interview Experience (On Campus) for Member Technical Staff
Apti + Technical Test: There were around 4 sections, all the sections were further divided into few subsections. Apti: Quantitative, logical reasoning, Flowchart questions. Coding skills: C++ output questions, Computer Science knowledge: Data Structures insertion, deletion related questions, many questions from AVL Trees, BSTs, stack and queue oper
4 min read
Oracle Interview Experience for Technical Staff Member (On-campus)
Oracle visited our campus for the Member Technical Staff role in November. Due to Covid-19, hiring was entirely virtual. CGPA cutoff was: 7.0 Below is the process and my experience: Round 1(online test): The test was conducted on Oracle’s platform Taleo. The test was majorly divided into 4 sections: Aptitude: Conventional aptitude questions, I prep
4 min read
Oracle Interview Experience for Member of Technical Staff (On-Campus)
Recently Oracle has visited our campus for hiring final year students for a full-time role. It was open for the Member of Technical Staff position. The selection process consisted of 4 rounds. The cut-off was 7.0 CGPA & above and CSE, IT and ENTC departments can only apply. There were a total of 4 rounds which include 1 online test and 3 interv
3 min read
Oracle Interview Experience for Member of Technical Staff (On-Campus)
Oracle came to our campus for Member of Technical Staff FTE positions for two profiles - Server Technology and Oracle Financial Services. Round 1(Online Test): The test was conducted on their own platform, web cam were kepton the entire time and consisted MCQs questions from Qualitative AptitudeReasoningData Structure (A lot of questions from BST,
3 min read
Work Experience at Oracle as Member of Technical Staff
I was interning with Oracle India Private Limited last year and got the pre-placement offer from there. I have joined Oracle as a Member of Technical Staff (SDE-2) in the Block Storage Team of OCI. The initial pieces of training and fun events will help you to adjust and transfer from campus to corporate life smoothly. The team members as well as t
1 min read
Netapp Interview Experience for Member of Technical Staff | On-Campus 2020
Round 1 Online Assessment 90min 3 Coding questions30 MCQs from OS, CN, Linux, DBMS, etc. Round 2 Zoom Video Call Technical Round 1 (50 min): All the project Discussions mentioned in my resume in detail. (25-30min) 1 Coding question based on a string. Return true if either 1st char of word is Capital and rest are small or All Capital or All Small el
1 min read
Adobe Interview Experience | (For member of Technical staff)
Round 1:(Online Coding round) There were 3 coding questions in 1 hour and 30 minutes. Question level was easy and easy -medium. Given a bag of capacity 1 kg to 3 kg. The bag can contain a maximum of two items at a time and total weight of items in the bag should be between 1 kg to 3 kg (because of the capacity of the bag). There is an array of item
5 min read
Athena Health Interview Experience for Associate Member of Technical Staff 2020 (Virtual)
Round 1 (Online Test - Day 1): Platform: Hackerrank Duration: 90 minTypeNo.of questionsMarksMCQ 105 marks eachCoding 250 + 75 Mcq's were based on Data Structure, OS, Pseudo Code Output DBMS. Both Coding Questions were based on arrays and the difficulty level was moderate. I was able to complete all 10 MCQ's and one coding question of 75 marks and g
3 min read
Athena Health Interview Experience for Associate Member of Technical Staff 2021 (Virtual)
4 Rounds in total: Coding and MCQ (Day-1)Technical interview (Day-2 Forenoon)Managerial Interview (Day-2 Afternoon)HR (Day-3 Forenoon) Round 1:(Coding & MCQ) TIME: 90 Mins 10 MCQ's and 2 easy level coding questions. Given an encrypted string s and an integer k, decrypt each character of the string by finding the kth character behind it. Eg: str
3 min read
Practice Tags :