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.
To write a parser in Java, to call from command line
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.
What is the Heap and Stack? What is Linked List? why we use LinkedList instead of Array? Write function that finds 2nd smallest and 2nd largest number in a given array.
Linked list vs arraylist Java8 features Spring boot annotations Rest controller vs controller Api gateway Micro services architecture Spring cloud
employee list is given, print employee data as per requirement. Filter the data whose name start with A.
Viewing 5291 - 5300 interview questions