It took one week. I got a call from a consultancy. They said there was an opening at Facebook (contract) and the payslips would be through that consultancy. This role is for a Python developer, most likely to work on Python, SQL, and binary search trees.

Python Qs:

1. Write a program to find the most frequently occurring element 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 in level order traversal.
4. Write a function that accepts a file, counts, and returns the exact occurrence of a word.
5. Given list a = [1, 2, 3, None, None] and list b = [4, 5, 3], produce 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 out the lowest-paid employees working under each manager, excluding any groups where min_sal is less than 1000, and 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 the employee working as a clerk 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 name for department number 10 or 30, but where the grade is not 4, and who 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 the Chemistry department employees.
3. What are the uses of charts: Pie chart, Bar chart, Line chart, Pivot table, Combo chart (bar & line)?
4. Given 2 tables, fill the sales column using HLOOKUP.