Iksha Labs Interview Questions and Answers

Search for a target value in a rotated sorted array.

• Use binary search to find the pivot point where the array is rotated.

• Determine which half of the array the target value lies in based on the pivot point.

• Continue binary search in the appropriate half of the array to find the target value.

SQL query to find the second highest salary from an employee list

• Use the MAX() function to find the highest salary

• Use the WHERE clause to exclude the highest salary

• Order the results in descending order and limit the output to 1

SQL query to select duplicate names from a list.

• Use GROUP BY clause to group names together

• Use HAVING clause to filter out names that appear more than once

• Example: SELECT name FROM table_name GROUP BY name HAVING COUNT(name) > 1

I have 3 years of experience working with Ruby on Rails in various projects.

• Developed web applications using Ruby on Rails framework

• Implemented RESTful APIs for client-server communication

• Utilized ActiveRecord for database interactions

Inner join returns only the matching records between two tables, left join returns all records from the left table and matching records from the right table, right join returns all records from the right table and matching records from the left table.

• Inner join: returns only the matching records between two tables

• Left join: returns all records from the left table and matching records from the right table

• Right join: ret...read more