Interview Questions

How would you decide between using DISTKEY and SORTKEY?

Implement an algorithm to find the longest common prefix among an array of strings.

List customers with more than 5 orders.

List every combination of dept_name, employee_name, and city such that the employee belongs to the department and the same city in which the department is located.

Multithreading and Synchronization in Java - write code to manage synchronized threads

Replace words and perform string operations in Python (replace, vowel removal, word count, pattern check).

Reverse a string with special characters preserved.

Sort and merge arrays

Spark Coding: Using explode() Function to flatten nested arrays

Stuff Function for XML Usages

What role does the executor heap size play in preventing OOM errors?

Write Python code to remove duplicates from a string.

Write a Python program to calculate total spending, identify top 5 users by spending, and find the most purchased product

Write a Python program to reverse words in a string.

Write a function that replaces all characters in a list except for a given character

Add Row Numbers using window function in PySpark

Add a column to the Employees table that shows the name of the employee with the next higher employee_id.

Add a new column with manager names for each employee using a self-join.

Add a new column with the average salary by department.

Advanced SQL with CTEs and Conditional Joins