Innovalus Technologies Interview Questions and Answers

SQL query to get second largest salary of an employee from employee table

• Use ORDER BY and LIMIT to get the second highest salary

• SELECT MAX(salary) FROM employee WHERE salary < (SELECT MAX(salary) FROM employee)

• Use subquery to get the highest salary and then exclude it to get the second highest salary

Cannot answer without the code provided.

• Need to see the code to determine the output.

• Output may vary depending on the code.

• Cannot provide an answer without more information.

Test cases for image upload feature

• Verify that the image upload button is functional

• Test uploading different file formats (jpg, png, gif)

• Test uploading large files and verify that they are uploaded successfully

• Test uploading files with special characters in the file name

• Test uploading multiple images at once

• Verify that the uploaded image is displayed correctly on the page

Test cases to ensure successful purchase of a pen

• Verify that the pen is added to the cart

• Check that the correct quantity of pens is added

• Ensure that the correct price is displayed

• Test the payment process

• Verify that the order confirmation page is displayed

Print the second largest element in an array of strings

• Sort the array in descending order and print the second element

• Iterate through the array and keep track of the two largest elements

• Use a priority queue to find the second largest element