I received a call from a consultancy for a 1-year C2H position at Facebook, Hyderabad in October 2015. The first round was a 1-hour written test (Python, SQL, Excel). The second round, held the same day, lasted 2 hours and included more questions from Python, dynamic programming, OS concepts, and DB concepts. The third round, also a technical round lasting approximately 2 hours, involved puzzles and logic written in Python, along with complex SQL queries. The final HR round was telephonic, covering salary negotiation. I accepted the offer and planned to join within one month.

Python Qs:

1. Write a program to find the most frequent occurring word in a file.
2. Given a list and a number, find two numbers in the list that sum up to the given number.
3. Write a program to print a tree using level order traversal.
4. Write a function that accepts a file and a count, and returns the exact occurrence of a word based on the count.
5. Given lists a = [1, 2, 3, None, None] and b = [4, 5, 3], what is the output: [1, 4, 2, 5, 3, 3]?

SQL Qs: Given Employee & Department tables

1. Display ename, dname, even if there are no employees working in a particular department.
2. List the lowest-paid employees working under each manager. Exclude any groups where min_sal is less than 1000. Sort the output by salary.
3. Display the name of the employee who earns the highest salary.
4. Display the employee number and name for employees working as clerks and earning the highest salary among the clerks.
5. Display the job groups having a total salary greater than the maximum salary for managers.
6. Display the names of employees from department number 10 with a salary greater than that of ANY employee working in other departments.
7. Display those employees whose salary is greater than their manager's salary.
8. Display the grade and employee names for department numbers 10 or 30, but where the grade is not 4 and the employee joined the company before 31-DEC-82.
9. Display the second maximum salary from the table using a subquery.
10. Display those employees whose salary is less than their manager's but more than the salary of other managers.

Excel Qs: Given Employee & Department tables

1. Count the number of employees whose salary is greater than 20000.
2. Get the total salary for Chemistry department employees.
3. What are the uses of charts: Pie chart, Bar chart, Line chart, Pivot table, Con (bar & live)?
4. Given two tables, fill the sales column using HLookup.