Two Sigma 面经 + 求问onsite之后多长时间给结果# JobHunting - 待字闺中
c*7
1 楼
面的是test 职位,做了debug test3小时 + NYC onsite 5轮,每轮一小时,总体感觉
还不错,所以还挺期待。上周三面完,请问何时能给结果...
Onsite Technical questions:
1. Judge whether a number is a cube number. (For example, 1,8,27), and
write test cases.
2. Basic sql question, join two tables.
Brain teasers.
1000 bottles of water, only one poison, how many write rats do you need to
find the poison within the shortest possible time.
On the earth, you walk 1 mile south, 1 mile east, 1mile north, then you find
you are in the same position. Find all these positions on the earth.
3. An array represents stock prices, find the best buy and sell time.
Write test cases.
Find bugs in a java program(bit operation, null, arraylist delete).
4. Complex sql questions, group by, sql functions(min, sum, max).
Write a program to parse a text file.
The file is as follows:
Company, time, price
Microsoft, 9:00, 35
Google, 10:00, 200
Microsoft, 9:05, 35
Google, 10:05, 200
….
Find the price for each company at the earliest time. So the result should
be:
Microsoft, 35
Google, 200
Also, write a unix bash to solve this problem, only one line bash.
How to test a phone?
5. An int array [1,2,3…..100], every number have only and if only one in
this array.
How to test it? Show the criterias. Write a program to test it.
Find all anagrams in a txt file. write test cases
暂时就能回忆起这么多,再补充吧,求bless...
还不错,所以还挺期待。上周三面完,请问何时能给结果...
Onsite Technical questions:
1. Judge whether a number is a cube number. (For example, 1,8,27), and
write test cases.
2. Basic sql question, join two tables.
Brain teasers.
1000 bottles of water, only one poison, how many write rats do you need to
find the poison within the shortest possible time.
On the earth, you walk 1 mile south, 1 mile east, 1mile north, then you find
you are in the same position. Find all these positions on the earth.
3. An array represents stock prices, find the best buy and sell time.
Write test cases.
Find bugs in a java program(bit operation, null, arraylist delete).
4. Complex sql questions, group by, sql functions(min, sum, max).
Write a program to parse a text file.
The file is as follows:
Company, time, price
Microsoft, 9:00, 35
Google, 10:00, 200
Microsoft, 9:05, 35
Google, 10:05, 200
….
Find the price for each company at the earliest time. So the result should
be:
Microsoft, 35
Google, 200
Also, write a unix bash to solve this problem, only one line bash.
How to test a phone?
5. An int array [1,2,3…..100], every number have only and if only one in
this array.
How to test it? Show the criterias. Write a program to test it.
Find all anagrams in a txt file. write test cases
暂时就能回忆起这么多,再补充吧,求bless...