IEEE Student Branch OUCE

ORACLE

About

ROLE: 

  • Netsuite Verticals
  • Developer
  • PDO

CTC: 18 LPA

ELIGIBILITY:

  • B.Tech & M.Tech with specialization in CSE/ECE/EEE/IT/MCS (CS/IT & Circuit branches); research students are not eligible.
  • 7/10 or above or percentage equivalent to 70% or above.
  • No Active Backlogs in any semester.

NO. OF RECRUITMENTS: 3

Selected Candidates

NAMA HARSHITHA

Department: CSE

 

The online test consisted of 10 questions. 7 were mcqs on DSA (mostly on trees and graphs).one was coding question(DP),one was SQL query, one was REST API.

“(Technical)
Self Introduction
Problems:
1.Rotate a one dimensional array by two places in linear time and using constant space(O(1)).
2.Given an array consisting of positive and negative elements, arrange the array alternatively in linear time and using constant space.
The interviewer asked me about the projects mentioned in my resume.
She also asked me some questions based on OOPs,Javascript .
Finally,she gave me a puzzle to solve-
Given a 5 litre and a 3 litre jars which are empty initially.you have to measure 4 litres using those 2 jars.(There were no markings on jars).

“(Technical)
Self-Introduction
Brief about my projects.
The interviewer asked me to open my portfolio project in my local system and explain it step by step(how i developed).He also asked me to open paint app and draw the working flow of my project.
Following this,there were two coding questions being asked.
Problems:
1.Program for Spiral traversal Of a 2D matrix.
https://leetcode.com/problems/spiral-matrix/
2.Given a string consists of words(need not be separated by a single space),count the number of words in it.
It was a modification of -https://practice.geeksforgeeks.org/problems/count-number-of-words1500/1

“(Technical+HR)
Self Introduction
Some common HR Questions like:
1.what are your strengths and weaknesses?
2.why oracle?
3.where do you see yourself in the coming 5 years?
4.Being having a good academic score,why don’t you choose to go for higher studies?

Technical:
1.Design whatsapp database and explain relationships between different tables.(He asked me to open paint and draw different tables,attributes and relationships)
2.You have to design a new Railway station .Then what’s your analysis and how do you decide the number of platforms to be constructed.
3.A box with old type (traditional lock) of lock is locked and sent to your friend but key is not sent to him.Then ,how can he open the box?(It’s based on Asymmetric Encryption in Operating Systems).
Finally,he asked me if I had any questions for him.

I wasn’t selected but I hope my interview experience helps you in your preparation.

“1.Be Confident.
2.Focus on Coding and OOPs
3.Be well prepared with your resume.
4.Make sure you are strong enough in DBMS.

D. ASHISH

Department: ECE

 

“3 Coding questions: 1.DSA 2.Rest API 3.SQL and
remaining questions are MCQ’s based on concepts of DSA (mostly on trees).”

“Tell about yourself (all rounds) .
Basic questions on oops concepts(inheritance example , how to achieve data abstraction, exception handling).
Real life examples of stack.
Sorting methods.
Coding questions:
1. Reverse a string using stack
2.Find the pairs in array whose sum is equal to k(optimised).
3.Find the second largest element in an array using insertion sort and bubble sort.

“Explain about your project and some project related questions
Explain about ACID properties(DBMS).
Explain about Left outer join (SQL).
Basic SQL query.
Coding Qns :
Diameter of a tree(optimised).
Find the given element in a sorted and rotated array with time complexity of logn.
How to remove loop in a linked list.”

“What is the version of Java you are familiar with.
Explain the features of Java 8.
Reverse a linked list.
Boundary traversal of a binary tree.
Why you are interested in IT job .
Do you have any abroad plans.”

“Practice more questions on DSA.
First tell the approach of the question to the interviewer and then start solving (they should satisfy with your aproach).
Questions are asked based on the skills you mention in your CV .
Best of luck to all.”

GOPAL KAUL

Department: CSE

 

The test was online. One question was programming(problem solving), another was a question to fetch some data using REST APIs, and the last one was an SQL query. Remaining questions were MCQ types, around 8 or 9. The test had a total of 11 or 12 questions.

The first round was held on Zoom. I was asked on how to count the frequency of characters in a string, and to find the letter with the maximum frequency.The first round was held on Zoom. I was asked on how to count the frequency of characters in a string, and to find the letter with the maximum frequency.

“The next round was where I was asked to solve a programming question. The question was as follows –
Given a string, reverse the string and all the words *except* the word with the second highest frequency using a recursive function, and the string and the words both should be reversed inside the same recursive function.
I used Python for all the rounds. I couldn’t finish the solution in time, however I was really close and the interviewer understood my approach and so I proceeded to the next round.”

This was the final and HR round. I was asked a few SQL questions, about normal forms in databases, and a few basic puzzles. Then, I was explained about the role and I was asked if I was interested to join.

“Go through –
1. Working with REST APIs
2. SQL
3. DBMS and Normal forms

Just go in with a clear mind and be confident!”