Oracle Interview Expertise – GeeksforGeeks

Interview Spherical 1: 

• Distinction between multiprocessing and multithreading.
• SQL Question to seek out the nth highest wage within the worker desk. I wrote one utilizing nested queries. However he requested me to jot down a generic one which I didn’t know and I merely instructed him that I’m not good at writing SQL queries.
• A basic math downside: A horse travels one mile in two minutes in a single route. It travels a ways in three minutes in wrong way attributable to wind. Discover the time taken to journey one mile when there isn’t any wind.
• Write the code to seek out the peak of the Binary tree (I used to be coding in python however he particularly requested me to code in C which I did however missed a whole lot of semicolons >_< which he particularly identified and requested me to finish these).
• What are your weaknesses?
• What are your strengths?
• Why ought to we rent you?

Interview Spherical 2:

• Describe your internship mission. I used docker as an internship so I used to be requested questions on containers, digital machines, and many others.
• Describe one of many tasks you might have talked about in your resume. No cross-questioning.
• I used to be requested a coding query that I don’t keep in mind. It was simple.
• I used to be requested to jot down code for locating the longest palindromic substring in a string. First, he requested in regards to the method, after which I coded it utilizing the brute pressure method. I used to be requested to optimize it, then I defined to him the method and coded the optimized method.

Interview Spherical 3: This spherical was taken by the Director of Improvement. He took our pre-placement speak too.

• I used to be stunned when he instructed me that I’ve obtained the suggestions that you’re superb at problem-solving (This was his beginning line and tbh I’ve by no means finished any sort of aggressive programming, I don’t even have CodeChef, code forces, interview bit profiles and made a leetcode profile after the beginning of placement season). He requested if I remedy issues on leetcode and I instructed him that I’ve solved 30-35 issues solely. 
• He requested me about programming language choice and I instructed python. Then he instructed me he hasn’t used python a lot after which requested me about shallow copy and deep copy in python. I used to be requested to point out it utilizing code.
• Then I used to be requested a two-sum downside the place we needed to print all of the pairs summing as much as a given quantity. First I gave a brute pressure method utilizing two loops after which optimized it utilizing a HashSet. I gave a two-pass resolution first after which he requested me to do it in a single move, which I did.
• Then he requested me: Discover the minimal variety of deletions to make a string palindrome. A easy dynamic programming downside. So I instantly coded it utilizing dynamic programming with out going into the brute pressure method.
• Every little thing was going properly until now however now began the troublesome section. He mentioned that I’m too one-dimensional and I’m not open to new concepts (as a result of I used to be doing all the pieces in python). I defined to him that after we began having ML topics within the Fifth-semester python grew to become a necessity and since then I obtained used to it and began utilizing python for actually all the pieces. Then he began explaining how python remains to be thought of a scripting language and never a programming language. He mentioned that I will be unable to work in java. Then I instructed him that we used to work in Java nevertheless it’s solely up to now 12 months I’m utilizing python. Then he began asking questions on it which I hardly answered. Questions have been:
• Distinction between string buffer and string builder.
• What’s using “String [] args” as a parameter to the primary perform in java. (I answered solely this query).
• Will this system run if we write solely “predominant()” as an alternative of “predominant(String [] args)”?
• Will this system run if we write “Primary(String [] args)” as an alternative of “predominant(String [] args)”?

Then he requested me to persuade him that I might be capable to work in java if chosen. Which I hardly managed by saying that like I’ve tailored to python, I can return to java once more. It’s all about adaptation. To which he replied, then a rag picker can even adapt why have I come for hiring in IIITA? I had no reply to this. After this, he requested me if I’ve any questions as a result of for the final 40 minutes, he was the one one asking questions and he want to reply my questions too. I requested him in regards to the values of the corporate. I additionally instructed him that it was a shock to see him because the interviewer as a result of I didn’t count on him to be the director after taking the pre-placement speak to take interviews too. Then he requested me in regards to the interview expertise and after that, I used to be requested to go away the decision.
For others, it was purely HR spherical the place they have been requested about faculty life, faculty life, childhood, members of the family, and many others.
The outcomes have been declared late at evening and I used to be among the many selects.