Oracle Interview Experience | Server Technology Role | On Campus (Full Time)

ROUND 1 (Technical)Introduce yourselfTell me about your projectsGiven an array 1,2,3,4,5.

Output 120,120,60,20,5 (Each element in the output is the product of all the elem...

ROUND 1 (Technical) Introduce yourself Tell me about your projects Given an array 1,2,3,4,5.

Output 120,120,60,20,5 (Each element in the output is the product of all the elements starting from that index) Write code and time complexity. Difference between abstraction and inheritance. SQL Query - given table student with attributes name, subject, and marks. Find the topper of each subject and return their name, subject and marks for that subject. I gave a solution using a nested query. So follow-up question was asked - write without using nested query. Explain your deep learning project. Disadvantages of LSTM (follow up on project) Difference between “where” and “having” in SQL. Why Oracle? What if another company offers to pay you more? Any questions? ROUND 2 (Technical) Introduce yourself. Buy and Sell Stock problem with wordings changed. Buy and sell stock plus short selling. Short selling means we are allowed to sell first and then buy later. Buy and sell stock where you HAVE TO sell first and then buy. Cannot buy first. Row-wise sorted and column-wise sorted matrix.

Return the index of number K. https://www.geeksforgeeks.org/aptitude/puzzle-20-5-pirates-and-100-gold-coins/ https://www.geeksforgeeks.org/aptitude/puzzle-31-minimum-cut-puzzle/ Difference between Bootstrap and react (based on a resume) How does the browser know bootstrap keywords? Which language does the browser understand? Perform dfs in matrix with 1s and 0s. Count the number of connected components in matrix with 1s and 0s. How does the SQL query efficiently search for the required row in the database table? Any questions? ROUND 3 (HR) Introduce yourself. Tell me about your projects. Tell a bit about ML and DL. Tell me about your ML and DL projects. What is important in teamwork and collaboration? What are your strengths? In recent times, have you experienced any conflict of interest? How did you manage it? What is some latest work being done in the AI-ML field? Have you had any new idea that you think might be implemented and is needed in the market? Where do you see yourself in the future? Short term and long term goals? Favourite programming language? What is a global variable? What are some skills required for leadership? Any questions?