Oracle visited our college on 11 September 2020. It offered two profiles : i) Application Developer ii) Server Technology.
ONLINE TEST : The Online test was of 107 minutes. It consisted of four sections.
Section 1 – Aptitude : It was having question on time & work, speed, Data Interpretation, etc.
Section 2 & 3 : Questions on CS core subjects like OS, DSA, DATABASE, CN.
Mainly the question were on AVL trees, Stack, Queue, Linked List, Output based question on Recursion, etc.
Section 4 – Verbal Ability : This sections consists of questions on Sentence Completion, Comprehension, Arranging Sentences in correct order to form a meaningful Paragraph, etc.
Each Section is further divided into 3-4 subsections with each subsection having its time limit. Eg – A subjection containing 7 question with 5 minutes, 4 question with 6 minutes, etc.
You are allowed to take a gap of 1-2 minutes between each section but no time gap between subsections.
After 4 days results declared and 40 students got shortlisted for Application Developer and 51 students got shortlisted for Server Technology. I got shortlisted for Application Developer Profile.
ROUND 1 ( TECHNICAL ~ 45 – 50 min) :
1. The interviewer started by asking how your lockdown is going on. Just asked to put in comfort zone.
2. Tell me about yourself.
3. Given a array containing 1’s and 0’s. Write a code to find maximum subsequence containing equal no. of 1’s and 0’s. https://www.geeksforgeeks.org/largest-subarray-with-equal-number-of-0s-and-1s/
4. Tell me about any incidence where you face some problem in academics and then how you overcome it. Eg – You can talk about difficulties you faced while completing you project and how you found a solution for it.
5. Now he asked me if i have any questions to ask. I asked 4-5 questions. It is always good to ask questions.
ROUND 2 ( TECHNICAL ~ 1:10 – 1:20 Hr ) :
1. Then interviewer told me that you know a about NETFLIX. Now you have design ORAFLIX same as NETFLIX, how you will design it. I started explaining him then he told me explain it in terms of SDLC. I explained all the steps of SDLC i.e requirement, design, coding, testing, deployment, maintenance. He asked few question in between while i am answering, i.e what will we different users, you will select the technology, database, OS, etc. you will use in design phase or coding phase, how you will deploy you project and have you ever deployed any project. I talked about heroku and pythonanywhere.com where i deployed my project.
2. Given a stack how you will reverse its content without using any other data structure.
https://www.geeksforgeeks.org/reverse-stack-without-using-extra-space/
3. Given a BST and a low and high value how will you print all value between low and high. Refer DSA by Narashima karumanchi book Tress Chapter.
4. Given a string how you will remove consecutive repeating characters. Eg: ‘abbac’ should return ‘c’.
5. There were 5-6 more coding questions which i can’t remember. Means a total of 8-10 coding questions were there with average to hard difficulty level.
6. Now he asked me few SQL Queries :
a) Write a Query to copy one table into another table i) with data ii) without data i.e only schema
b) Write a Query to delete all employees having salary > 1000.
c) Write a Query to delete all data of a table preserving Schema.
6. He asked me what is your favourite subject ans i answer OS. Now it followed questions on OS.
7. What is boot loader.
8. What is virtualization.
9. What is Virtual Machine and how it works.
10. As you are using Linux, so what file system does Linux users.
11. What is Iaas, Paas, Saas. Give examples of each.
12. 1-2 more question on OS which i can’t remember.
13. Diff between Set and List.
14. What is MAC and its full form.
15. What is OSI Model. Explain each layer.
In this round i was able to answer nearly 70% coding questions and for remaining questions i formed partially correct answers with the help of interviewer. The interviewer was very supportive.
I answered almost all the theory questions.
#interview experiences #marketing #on-campus #oracle
