Millennium Management Interview Questions

Can you explain the difference between inner and outer joins?

What is the difference between a list and a set in programming?

Given a Product table with columns [ProductId, Name] and records [1, Apple], [2, Orange], [3, Pear], and an Order table with columns [ProductId, Quantity] and records [1, 7], [2, 8], what SQL query produces [ProductId, Name, Quantity] such that the result is [1, Apple, 7], [2, Orange, 8], [3, Pear, 0] (with 0 for products not in the Order table)?

Implement a recursive function to compute the nth Fibonacci number.

How can you prevent gradient instability caused by the sigmoid function?

Explain Java collections and how you use them.

Given a product table [ProductId, Name] with records [1, Apple], [2, Orange], [3, Pear] and an order table [ProductId, Quantity] with records [1, 7], [2, 8], write the SQL query to produce [ProductId, Name, Quantity] where missing quantities are shown as 0. The output should be: [1, Apple, 7], [2, Orange, 8], [3, Pear, 0].

Write a recursive function to compute the nth Fibonacci number.

Implement Ordinary Least Squares (OLS) regression in Python using NumPy.

What is the difference between a dict, a list, and a tuple in Python?

Design a game using a fair coin in which the probability of winning is exactly p, for some 0 < p < 1.

Explain the statement of Fermat's theorem.

What are the limitations of the local volatility model?

How could you apply natural language processing (NLP) techniques to determine whether a stock will outperform the market or not?

You have a 6-hour case exercise with the following tasks: 1) Download the latest ADV reports from the SEC website and parse them to extract information about various funds, including name, address, phone number, and number of employees. 2) Implement error logging and write log entries to a local SQLite file. 3) Clean and transform the data to extract insights such as fund size by assets under management (AUM) and number of employees. 4) Create an API to expose the processed data. 5) Write mock tests for the API. 6) Create visualizations based on the extracted data.

Write an ordinary least squares (OLS) linear regression implementation in Python using numpy.

Is a tuple inside a list immutable or not?

Design a game using a fair coin such that the probability of winning is p, where 0 < p < 1.