SQL: 1. given table products(product_id, brand_name,product_name, product_price), find brand_names with avg price > 3 and having more then 5 products 2.given table sales (sale_id, promotion_id, sale_amount, other columns), find % of how sales with promotions ( promotion_id is null) are doing in comparison to all sales. Coding(Java): 1. find avg word length in a sentence 2. ip address validation 3. Friends problem [[A,B], [B,D],[E]...] ( List of lists);
Given a purchase table(user, purchase_time, amount_of_money, level1_category, level2_category), write a sql query to find the customer purchase in continue 7 days and with the total money greater than 500
If you take 3 subsequent number (n, n+1, n+2) and know, that n and n+2 are prime numbers, can you proove, that n+1 is always dividable by 6?
Questions on the video call were technical, but basic. 1. What are ACID properties 2. What are indexes 3. What is the difference between Stored Procedures, Functions and Triggers 4. BASE properties 5. JVM, JRE, JDK and JIT 6. What are common table expressions 7. Difference between throw and throws in java 8. What is the difference between Clustered and non clustered index
Are you good and praticale in fixing stuff and object ?
# Q1: Write a function to intersect two *sorted* lists (find common elements) # Write a method taking two lists as input, and returning a new list # You can assume you have a reasonable array/list class available (ArrayList, vector, python list, etc) # Ex: # l1 = [1,2,3,4,5] # l2 = [1,5,7,11,100] # result = [1,5]
Implement a library function which takes a collection of integers (Collection<Integer>) computes its sum and returns the result. The implementation must establish preconditions which ensure lack of runtime error(s). Implement the above function using recursion only.
Explain how to get information from Excel over to the database
List the strings that are anagrams from a set of strings?
A lot of SQL questions. General knowledge about how you would handle large amounts of data.
Viewing 81 - 90 interview questions