Oracle Developer interview questions

2 Technical questions. 1. Subarray Sum Equals K Given an array of integers nums and an integer k, return the total number of subarrays whose sum equals to k. A subarray is a contiguous non-empty sequence of elements within an array. 2. Find Substring in a string problem.

I had interview consisting of 2 rounds and both in my managerial and the technical round I was asked questions mostly based on SQL. We need to write the query sometimes and some basic programming questions