I recently had an Oracle Onsite Interview and was asked these questions in the coding rounds.
For design I was asked to design a system which takes regular metrics from a number of servers and the return max of the metric for different time window (hour/minute/day).
Besides this there were behavioral questions pretty much in every round.