Oracle Interview Experience

ORACLE PLACEMENT TIPS

Founded: June 16, 1977; 40 years ago, Santa Clara, California, U.S.[1]

Founder:  Larry Ellison, Bob Miner, Ed Oates

Headquarters: Redwood Shores, Redwood City, California, United States

Area served:  Worldwide

Key people:  Larry Ellison (Executive Chairman & CTO)

Jeff Henley (Vice Chairman)

Safra Catz(CEO)

Mark Hurd(CEO)

Oracle is global IT service provider headquartered in Redwood City, California, US. The company provides databases & application products along with consulting, education & support services. 

The Oracle Test-Pattern and Selection Procedure is as follows:

The company conducts recruitment process every year to select new candidates. The selection process of the company consists of 3 rounds. 

These rounds are as follows:

Written Exam

Technical Interview

HR Interview

Academic Criteria:(may vary)

60 percent or above in B.Tech , Class X and XII.

Gap of upto one year is allowed.

Pattern of written Test

(sometimes technical section no. of questions may increase with sub section from datastructures, algorithm, operating system, databases, software engineering etc)

Testing Areas

No. of Questions

Time (in minutes)

Verbal

15

25 mins

Quant+Reasoning

20 + 20

35 mins

Technical

20

30 mins

Total

75

90

The total time allotted to the written exam is 90 minutes.

Verbal Ability section consists of short reading comprehension passages. This section also consists of basic grammar usage questions like fill in the blanks, synonyms, antonyms, paragraph completion, sentence correction, vocabulary, sentence ordering etc. The time allotted to this section is 25 minutes.

Quantitative Ability & Logical Ability section consists of questions based on topics like algebra, time & work, time, speed & distance, arithmetic, percentages, probability, permutation & combination, profit & loss, HCF, LCM, geometry, etc. This section is of moderate level. The time allotted to this section is 35 minutes.

Technical section involved questions from Computer science subjects like Data structures, OS concepts, DBMS & CODD fundamentals, Big O notations, etc. This section requires thorough preparation and a candidate with conceptual clarity and strong knowledge of the fundamentals would excel. The time allotted to this section is 30 minutes.

Data interpretation and Logical Ability Section consists of basic questions from DI involving some complex calculations and Other logical ability based questions , based on concepts like arrangements, hierarchy etc.

Overall the level of the paper is moderate to difficult. Only those candidates who clear the written exam will qualify for the next round.

*The Company reserves the right to make changes in the written exam and eligibility criteria.

***********************************************************************

INTERVIEW EXPERIENCE (Harika Kartick)

***********************************************************************

I got selected in Oracle PGBU. 

The cutoff was 7* CGPA. (sometimes vary)

The package is 7 LPA.(changes with time ) 

There is an initial online qualifier, which required us to write a piece of code, in any language you prefer: C, C++, Java.

 Talking about the work here, we use JavaScript and API's like jQuery, lodash and handlebars.

 There are other teams in PGBU that use Java and Applets so there is something for everyone.

 It is absolutely fine if you don't the first thing about these. 

They don't judge you on this basis. In fact, it won't even be mentioned. 

But if you are fluent in any of these, it might work to your advantage in interview rounds, hence, I mentioned it here. 

If you aren't comfortable in any of these languages, don't worry, you will get a proper training on joining. Focus on what they ask right now. 

Some things I can suggest to juniors for later rounds of PGBU:

> You will be judged equally on analytics and coding. 

> Whatever code you write in the written, try to make it unique (logic wise). 

This will not be mentioned by them, but that is how I got through. 

Try optimizing code without cluttering or complicating it. The code doesn't have to be long. That impresses NO ONE. 

> There will be a written test with equal weightage on analytics and code, after which they will select you for the interview.

> If you do better in 1 section, your interview will be focussed on the other part.

> My interview centered around analytics. Try finding questions like minimum length that can't be measured using 3 ropes/logs of 3 distinct sizes, available in as many numbers as you want. They asked this one to almost everybody for PGBU. 

> Be clear about the code you have written. They might ask you to optimize it further during the interview. Optimization on sorting and searching will not impress them so much, but if you are able to find some unnecessary step, or a mathematical relationship, or Boolean shortcuts for optimization, you can really affect the course of the interview. 

I'll give an example: 

we were asked to find the next larger number using the same digits in the given number. eg: if the number is 124, the answer is 142.

> The logic that you instinctively follow: extract each digit, make all possible combinations, sort them, and look for the number in the next index in the sorted array.

> The logic I applied: Increment the given number by 1 and in each loop compare if it contains all the given digits. This will ascertain you get the next larger number, in a less complicated way.

> Upon asking to optimize it (they gave me 5 minutes): I realized that you don't need to increment by 1, you can increment by 9. The difference between any combination of the same digits will always be in multiples of 9. (142-124=2*9), (991-199= 88*9) you can try it! Although there will still be looping required, the code gets optimized by 9 times.

These things will not be taught to you, nor will there be a training available anywhere. 

You can only observe these and hope you can correlate it when you need it. They will try to confuse you during analytics, be confident.

All this being said, it will be very hectic during placement. 

Don't let it drag you down. You need to do justice to every exam that you write, every interview that you get. 

Give your best everywhere, you will land where you are meant to and after these 2 semesters, it won't seem like such a big deal.

All the very best, you guys! Hope to see more MITians in the team :)

Thanks to Harika Kartick for sharing her experience. 

Jay Jagannath Swami Nayana Patha Gami Bhaba Tume Bhaba Tume ...  

Mr. Tribikram Pradhan

Research Scholar, Dept. of CSE

Indian Institute of Technology, (BHU), Varanasi

E-Mail:  tribikram14@gmail.com