Lead Programmer Interview Questions and Answers

Use SQL query with ORDER BY and LIMIT to find 3rd highest salary from employee table.

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 2,1 to skip first two highest salaries and get the third highest salary

• Example: SELECT salary FROM employee_table ORDER BY salary DESC LIMIT 2,1

CORS policy allows or restricts cross-origin requests in web APIs.

• CORS stands for Cross-Origin Resource Sharing.

• It is a security feature implemented by browsers to prevent unauthorized access to resources on a different origin.

• CORS policy is enforced by the browser based on the response headers sent by the server.

• Access-Control-Allow-Origin header specifies which origins are allowed to access the resource.

• If the request origin does not match the allowed origins, the browser w...read more