Media.net Software Services (India) Interview Questions, Process, and Tips

Q1. Second highest Salary
Ans. 
To find the second highest salary in a database table, you can use a SQL query with the ORDER BY and LIMIT clauses.
• Use a SQL query with ORDER BY clause to sort the salaries in descending order.

• Use LIMIT 1,1 to retrieve the second highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1;
Answered by AI
Add your answer
Q2. Left and right join explanation
Ans. 
Left join includes all records from the left table and matching records from the right table. Right join includes all records from the right table and matching records from the left table.
• Left join: Returns all records from the left table and the matched records from the right table.

• Right join: Returns all records from the right table and the matched records from the left table.

• Example: Left join - SELECT * FROM table1...read more
Answered by AI
Add your answer

Q1. Question on Binary Search tree
Add your answer
Q2. One easy array question
Add your answer

Q1. DSA easy-medium
Add your answer
Q2. HTTP/HTTPS, web fundamentals
Add your answer

Q1. DSA medium (array, two pointer based)
Add your answer
Q2. Project based questions were asked
Add your answer
Q3. DSA easy - medium on string
Add your answer

Time and distance, profit-loss

Basic programs like fibonacci, find second largest/smallest

Q1. Why are you switching
Ans. 
Seeking new challenges and growth opportunities in software testing field.
• Desire to work in a more challenging and dynamic environment

• Interest in gaining experience in software testing

• Opportunity for career growth and development
Answered by AI
Add your answer
Q2. Salary discussion
Add your answer

Q1. Dsa easy medium array question
Add your answer
Q2. Dsa medium tree question
Add your answer

Q1. Web fundamentals
Add your answer
Q2. Dsa medium two pointer question
Add your answer