Cloudera
Details
Job Status
Full Time (Employment + Internship Mandatory)
Criteria
| Study | Cutoff |
|---|---|
| X | 8% |
| XII | 8% |
| UG | 8 GPA |
- Cutoff was increased after initial registration.
Round 1
21/08/23
3 Questions:
- SQL (1)
- Coding (2)
Coding Questions
- Find the 2nd largest value: Write an SQL statement to print the second largest value from a column, if it doesn’t exist, then print null.
SELECT DISTINCT PRICE FROM PRODUCTS ORDER BY PRICE DESC LIMIT 1, 1;
- Should have worked but didn’t.
- Lines passing through special point: Given a 2D plane and a special point (p) and n other points (x1, x2…xn). Find the number of pairs of points amongst the n points that pass through the special point.
Finding the slope of each point wrt to the special point, if for some slope m, there are q number of points with the same slope, then the number of pairs of lines that pass through the special point would be
(q * (q - 1))/2
- Nearest Prime: Given a list of integers, if the number is not a prime, then find the closest prime and print that number, else do nothing.