Tower Research Capital LLC Interview Questions and Answers

10 bags with 10 coins each, one bag has 0.9 gm coins. How to find it using weighing machine once?

• Number the bags from 1 to 10

• Take 1 coin from bag 1, 2 coins from bag 2, 3 coins from bag 3, and so on

• Weigh all the coins together

• Subtract the expected weight (550 gm) from the actual weight to get the bag number with 0.9 gm coins

Cut the cake twice horizontally and once vertically to make 8 pieces.

• Make two horizontal cuts to get three layers

• Make one vertical cut through the center

• Total 8 pieces will be obtained

SQL query to find employees with salaries in a certain range.

• Use the SELECT statement to retrieve data from the table.

• Use the WHERE clause to filter the data based on salary range.

• Use the BETWEEN operator to specify the salary range.

• Example: SELECT * FROM employees WHERE salary BETWEEN 50000 AND 70000;

The WHERE clause is used to filter data in a SQL query.

• It is used to specify a condition to filter the rows returned in a SELECT statement.

• It can be used with various operators such as =, <, >, LIKE, etc.

• It can also be used with logical operators such as AND, OR, NOT.

• Example: SELECT * FROM customers WHERE age > 18 AND city = 'New York';

The DELETE function in SQL is used to remove rows from a table based on specified conditions.

• DELETE FROM table_name WHERE condition;

• The DELETE statement without a WHERE clause will delete all rows in the table.

• It is important to use the WHERE clause to avoid accidentally deleting all data in a table.

• Deleted rows can be recovered using a backup if needed.

Sieve of Eratosthenes is an algorithm used to find all prime numbers up to a given limit.

• Create a list of numbers from 2 to the limit.

• Start with the first number in the list (2) and mark all its multiples as composite.

• Move to the next unmarked number in the list and repeat the process.

• Continue until all numbers have been processed, the unmarked numbers are prime.