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.
Given a large file that does not fit in memory (say 10GB), find the top 100000 most frequent phrases.
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.
employee list is given, print employee data as per requirement. Filter the data whose name start with A.
Explain Transaction management in hibernate.
Tell about config file in hibernate. How you will configure hibernate without using data jpa.
What all conditions are there to use an ArrayList and LinkedList?
Since my domain was telecom OSS, they asked me to design a Device sync module with a certain conditions.
Viewing 551 - 560 interview questions