Developer Database Oracle Interview Questions

Front End Developer

Interviewed at LinkedIn

3.8★

Jan 8, 2019

// Given var endorsements = [ { skill: 'css', user: 'Bill' }, { skill: 'javascript', user: 'Chad' }, { skill: 'javascript', user: 'Bill' }, { skill: 'css', user: 'Sue' }, { skill: 'javascript', user: 'Sue' }, { skill: 'html', user: 'Sue' } ]; getSkills = (endorsements) => { // Result // [ // { skill: 'javascript', user: ['Chad', 'Bill', 'Sue'], count: 3 }, // { skill: 'css', user: ['Sue', 'Bill'], count: 2 }, // { skill: 'html', user: ['Sue'], count: 1 } // ]; } see this image: http://i.imgur.com/UIeB3n4.png

Software Engineer Intern

Interviewed at Tripadvisor

3.5★

Oct 25, 2013

Given two sorted arrays. Write a method that returns the intersection of the arrays. Ex. [2,4,3,6] and [8,9,2,4] would return [2,4].

Software Engineer

Interviewed at Google

4.4★

Mar 23, 2011

Write a function that computes the intersection of two arrays. The arrays are sorted. Then, what if one array is really larger than the other array?

Software Engineer Intern

Interviewed at Google

4.4★

Jan 23, 2014

Given a TV remote, write a script that would give directions to input some letters. Starting from the upper left-hand corner. If the buttons were in 3 columns, and you wanted to type "feed", you would want the output of the program to say "right, right, down, PRESS, left, PRESS, PRESS, left, PRESS"

Software Engineer

Interviewed at Google

4.4★

Mar 7, 2015

Implement string rotateString(string input, int amt)

Software Engineer

Interviewed at Google

4.4★

Jul 24, 2010

Write a function that takes the ordinal number of a column in a spreadsheet and returns the label of that column: i.e. 1 -> A 2 -> B, 26 -> Z, 27->AA

Software Engineer

Interviewed at Google

4.4★

Dec 15, 2010

you have an array of stock prices. i-th element in that array represents the stock price of that day. find the buy and sell dates to maximize profit.

Software Development Engineer

Interviewed at Audible

3.5★

Nov 5, 2014

Using Collabedit, write a program to find the index of the first non-repeated character in a java string.

Machine Learning Software Engineer

Interviewed at Meta

3.6★

Jan 22, 2010

Suppose you have a matrix of numbers. How can you easily compute the sum of any rectangle (i.e. a range [row_start, row_end, col_start, col_end]) of those numbers? How would you code this?

Software Engineer

Interviewed at Meta

3.6★

Jul 18, 2011

Find Kth smallest element in a BST.