Company: Corridor Platforms
Difficulty: medium
Consider a table Employees(id, name, salary, department_id). Which SQL query returns the second highest salary? SELECT MAX(salary) FROM Employees WHERE salary SELECT salary FROM Employees ORDER BY salary DESC LIMIT 1 OFFSET 1; SELECT TOP 1 salary FROM Employees ORDER BY salary desc OFFSET 1 ROWS; SELECT DISTINCT salary FROM Employees ORDER BY salary DESC LIMIT 1 OFFSET 1; Which of the following describes thrashing? Excessive paging activity leading to low CPU utilization. High CPU usage due to frequent context switches. Multiple processes waiting on I/O simultaneously. Deadlock caused by circular waiting of resources. Which of the following CSS selector targets all <a> elements inside a <li> inside a class .nav inside an element with the ID header when hovered? #header .nav li a:hover .nav li a:hover header .nav li a:hover .header .nav li a:hover Which HTTP status code is sent currently when a client requests a resource it does not have permissions? 401 402 403 404 Which of