1) Write a query to rank order the following table in MySQL by votes, display the rank as one of the columns. CREATE TABLE votes ( name CHAR(10), votes INT ); INSERT INTO votes VALUES ('Smith',10), ('Jones',15), ('White',20), ('Black',40), ('Green',50), ('Brown',20);
I have a table for bugs from a bug tracking software; let’s call the table “bugs”. The table has four columns (id, open_date, close_date, severity). On any given day a bug is open if the open_date is on or before that day and close_date is after that day. For example, a bug is open on “2012-01-01”, if it’s created on or before “2012-01-01” and closed on or after “2012-01-02”. I want an SQL to show the number of bugs open each day for a range of dates. Hint: There are bugs that were never closed.
Write a Java method to calculate the Nth integer in the Fibonacci sequence.
MySQL query to rank order a table of votes.
Given a large file that does not fit in memory (say 10GB), find the top 100000 most frequent phrases.
Elevator Algorithm in which there are many floors and many lifts used to work. give a very optimal solution for so that waiting time will be less as much as possible. which design pattern will be used in this case. Other questions are related to profile.
1)Tell about your self. 2)Tell about oops concept.
Parse the album details which are in the form of list of strings and find out top ranking songs. Use java 8 lambdas.
write a program with good coverage
How circuit breaker is implemented
Viewing 5511 - 5520 interview questions