Oracle Principal Member Technical Staff interview questions

First round: Difference between in and exists in sql union vs union all list down features of Java8, Java7 Types of Garbage collectors List 5 JVM memory areas CountdownLatch vs Cyclicbarrier HashMap vs LinkedHashMap Factory vs abstract factory design pattern Remove loop from linked list Second round: Given 2 sorted arrays merge it into the first array which can accommodate both array elements Find max palendrome substring in given string Find any pair in sorted array which sums to given given number Problem of maven dependency resolution using topological sort. Third round: Design bookmyshow db schema, list all microservices identified, write a query to get threatres for given movie, city and date. What is data partitioning Microservice architecture, spring boot - just overview Design chess game

Operating System and Compiler Conecpts.