Oracle Software Development Engineer (SDE) II interview questions

coding round 1 1. given 4 arrays nameOfProducts, priceOfProducts, nameOfProductSold, sellingPriceOfProduct. count the products sold at price different from purchasing. 2. count of employees in each department sorted by count and also display 0 if no employee in some department 3. make a get request to given api and return data after some processing 4. length of sub array which contains element which has maximum frequency [ 1 2 3 2 0 3] => ans 3 sub array [2 3 2] Round 2 1. Rest vs Soap and when to use which 2. how to authenticate restapi 3. explain jwt 4 noSql vs Sql when to use which 5 encryption algorithm

- Streams, Filter, Spring batch, Files