oracle interview questions and answers | coding interview | Job interview

oracle interview questions and answers | coding interview | Job interview


Hello everyone I’m Surbhi Mittal from IT department, 8th semester from IGDTU I’m here to share my interview experience with you. I would like to thank Placement Boat for giving me this opportunity to share and express my views and for what all I went through in my interviews. I’m placed in Oracle and the package is 8 lakhs per year. Oracle is an American-based company that primarily specializes in developing and marketing the computer hardware systems and the enterprise softwares, primarily the database management systems of its own brand and the profile that was offered is server technology. The placement procedure had 3 rounds. First was the MCQ, the second was the programming round and the third was the interviews. The MCQ round was basically very time-constrained. It was divided in different sections and it comprised of questions based on data structures, logical ability, verbal ability and CPP, DBMS and data structures as well. And you have to be very quick and the questions were basically, mainly from avl trees, binary trees, BST’s and aptitude. 10 aptitude questions were there that has to be solved within 10 minutes. There were also a section in which 20 verbal ability questions had to be solved in 20 minutes. So, time limit was very constrained. Make sure that you put more focus on accuracy rather than attempting more questions. And yes, there was no negative marking. Then the second round was the programming round. It was a non-eliminating round and 2 programming questions were given that has to be solved within an hour. And it was a non-eliminating round and around 50 students were shortlisted after this round. The third were the interviews. I had to go through 3 interviews. In the first interview, the questions were asked based on my project. Make sure that the projects that you’ve mentioned in the resume are on your tips. Because many grilling questions are asked on your projects. So please go through your projects very well. Then in the first round only some programs were given on patterns like write a program giving output for pyramid of asterisk or the reversed pyramid..like pattern questions were also asked in the first round. Then in the second round was completely technical. In that first question was design snakes and ladder. I had to write a code for it. The second question was to draw the flowchart of the Flipkart site. And then I was asked to write a code for it. But I was also nervous at that time but the panel was really very helpful. whenever I got stuck they helped a lot. Then some data structure questions were also asked like merging of two linked lists, the basic questions from geeksforgeeks site. I would suggest you to go for geeksforgeeks site for data structures. Then in the third round again CPP was asked, C++. Like hashmap was asked in depth. And again a design question was given to me. Like I have to design the elevators in a mall, like what I would design for the elevators in the mall. So I have to give all the constraints and all the test cases had to be described clearly. Some puzzles were also asked to test my logical ability. Then the final round was..it was not actually a round. In that I was just asked that would I prefer to stay in Delhi or Bangalore, Hyderabad. And ya..some negotitations were done. And it was little bit talk. And then interviews were over. I would like to suggest you geeksforgeeks site, its a very very good site. that you should consult, not only for Oracle interviews but the interviews for any company. DS, CPP, and C – you should do these three subjects from geeksforgeeks site. And for DBMS, because Oracle is a database company, so they are going to ask some DBMS questions. For DBMS, you should consult Korth book. And indiabix is a very good site from which you can practice aptitude questions and RS Agarwal book is also there pretty much similar they both are. the site and the book. And also you should have good communication skills. They basically have some good impact on the interviewers. If you have any queries you can post it in the comments section. And to get more informative videos, you can subscribe the Placement Interviews channel which is the official channel for Placement Boat. Wish you a very all the best, thank you!

31 thoughts on “oracle interview questions and answers | coding interview | Job interview

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *