Oracle Interview Questions

Note: ensure you read the disclaimer on the previous page reading the accuracy and sourcing of these problems.

Find Missing Number in Array

We're given an array of continuous numbers that should increment sequentially by 1 , which just means that we expect a sequence like: 1, 2, 3, 4, 5, 6, 7 However, we notice that there are some missing numbers in the sequence. 1, 2, 4, 5, 7 Can you write a method missingNumb...

Difficulty: 4/10

Zeros to the End

Write a method that moves all zeros in an array to its end. You should maintain the order of all other elements. Here's an example: js zerosToEnd 1, 0, 2, 0, 4, 0 1, 2, 4, 0, 0, 0 Here's another one: js zerosToEnd 1, 0, 2, 0, 4, 0 1, 2, 4, 0, 0, 0 F...

Difficulty: 5/10

Find Shortest Palindrome Possible

We have a string str like the following: js const str "bubble" Find a way to convert it to a palindrome by inserting characters in front of it. Recall that a palindrome is defined as "a word, phrase, or sequence that reads the same backward as forward". What's the shortes...

Difficulty: 5/10

Reverse a String

Hey there, welcome to the **challenges** portion of the **AlgoDaily** technical interview course! Over the next few days, you'll get some hands on experience with the essential data structures and algorithms that will help you nail your interview, and land your dream software engineering job. The ...

Difficulty: 2/10

Implement a Binary Search Tree

Let's implement a Binary Search Tree ! Recall that a binary search tree , or a BST , is a binary tree lessons an intro to binary trees and search trees that is ordered via these two properties: 1. The left sub tree of a node has a value less than or equal to its parent node's value. 2. The ...

Difficulty: 6/10

Reverse a Linked List

You're sent a linked list of numbers, but it's been received in the opposite order to what you need. This has happened multiple times now, so you decide to write an algorithm to reverse the lists as they come in. The list you've received is as follows: 7 2 21 6 42 10 Write ...

Difficulty: 6/10

Remove Duplicates From Array

Given an array, return another array with just the ordered unique elements from the given array. In other words, you're removing any duplicates. Note: Order needs to be preserved, so no sorting should be done. And the order should be maintained with the first occurrence of the element in the given...

Difficulty: 4/10

Sum Right Side Leaves

Finding the Sum of Right Leaves in a Binary Tree Imagine a family tree, but instead of tracking your relatives, it's tracking numbers. Each "person" in this tree has at most two "children," and some have none. We call these childless nodes "leaves," and your task is to find the sum of leaves that...

Difficulty: 7/10

Invert a Binary Tree

Can you invert a binary tree over its vertical axis? This is a famous problem made popular by this tweet: Google: 90 of our engineers use the software you wrote Homebrew , but you can t invert a binary tree on a whiteboard so f**k off. mdash Max Howell mxcl June 10, 2015 Given a binary t...

Difficulty: 7/10

Is An Anagram

Understanding Anagrams: A Simple Definition An anagram is a fascinating literary device where you can rearrange the letters of a word, phrase, or name to form another meaningful sequence. Think of it as a jigsaw puzzle made of letters. For example, the word "cinema" can be rearranged to form "ice...

Difficulty: 3/10

Introduction to Amazon Redshift

Amazon Redshift **Amazon Redshift** is a cloud based data collection and storage service. Amazon Redshift makes it possible for a customer to use business intelligence, or BI, techniques to evaluate quantitative data and make managing large scale datasets simpler. In Redshift, **Big Red** refers...

Difficulty: 5/10

Data Modeling and Design

Introduction to Data Modeling Data modeling is a crucial aspect of data engineering that involves designing the structure of a database and defining the relationships between different data entities. It serves as a blueprint for storing, organizing, and manipulating data efficiently. In the fi...

Difficulty: 5/10

People at Oracle Say

This information was sourced from reviews originally posted on Glassdoor.

It's an amazing team with good communication and teamwork. Everyone works hard and does extra on bigger projects and attack projects as a team. Another pro is that Oracle is one of the bigger companies around the world, so it will look good on your resume for your next or future job. It is a great company to work at if you are joining as your 2nd or 3rd job in your career so that you are decently compensated already. Another good thing is that Oracle has the "unlimited PTO" as a benefit for salary employees, but it depends on your immediate manager to approve or not. My manager was amazing at allowing me to have time off when I needed.

My manager and team were absolutely the most skilled set of automation specialists across Oracle. It was a pleasure working with them and the atmosphere was truly outstanding. I was skilled enough to work in fields outside the scope of my original job title. Although my abilities were recognized, all my manager's requests for promotions within my part of the organizations where declined repeatedly. Stick with your priorities and see them through until your team have enough time to complete them and see them succeed. Do not continue to provide priorities that did not meet the companies long term goals. This accumulates to a complete waste of time and your developers will lack a sense of accomplishment.

Oracle is a low-stress environment with some incredibly brilliant people if you dig around for them. Corporate policies tend to be antiquated and slow to adapt, but they do adapt. Unrealistic college hiring standards and weak raises with dry promotions create a revolving door for top engineers, while low performers are just endlessly "reorganized" instead of being fired, continuously diluting the talent. Make more of an effort to retain your talent by providing reasonable bonuses and raises. Once these high performers leave, they're not coming back.

Solid lock on DBMS market which is not growing and now subject to competition from NoSQL offerings. Company allows to work from home. This is the best benefit. Total comp is below average. Employees are considered dispensable and there is minimal effort to invest in employees. Depending on which group you end up in you might end up in a very niche area that makes it hard to find new work.