SQL Question: Different SQL queries to find duplicates?
Developer Interview Questions
269,206 developer interview questions shared by candidates
First Round - Working of Hashmap, ArrayList Linked List, Java Basic questions Second Round - Coding Exercise - implement SecurityDataServices - Objective 1 1) SecurityServiceImpl - methods a)addSecurity(Security s) b)recordTick(long secID, Tick t), c)getPrice(Security s) d) getHistoricalPrice(Security S, TimeStamp asOfNow) 2)SecurityImpl - methods 1) getSecId() 2)getListTicks() 3)getCurrentPrice() 4)recordTick() 3) Tick Impl - methods 1) getPrice(), 2) getTimeStamp() Implement all these classes in 1.5 hr, Use multithreading, I used ConcurrentHashMap and CopyonwriteArraylist use atomic operations like putifAbsent() CodeReview questions - explain the flow of written code, explain java locks, write it using lambda expression, rewrite the code using locks 3rd round - behavioural questions - why do you want to join Sapient? extra activities apart from work? any technology that you follow?
2)How to clear an array by different way
basic que on oops and exception, Singleton patterrn, asked to write a simple array based program which further asked to optimize.
You are given an array with negative and positive unsorted numbers. Find out a pair whose sum = 0. If no such pair exists, find the pair whose sum is the closest to 0.
Onsite - 1. You have a computer with seven core cpu, you have a file and you have to read each line of the file, check if it has the word UPS in it, if so , then write it to a file, if there is no word as UPS in it, write that line to a different file. 2. An amount will be given as input. The amount will have some cents in change. So, for example $29.90. For the change, you have to start using the highest denomination and go to the lowest until the change value is completely met.
Are you willing to relocate to pune ?
if you use a console.log inside a timeout with 0 second how long would it take to print
is it possible to have a static class ?
Can we use the final keyword with the constructor?
Viewing 1291 - 1300 interview questions