Workid is the primary key.On the table worker, the following index is created.IX1 - job title, wages per dayWhich of the following queries will use TABLE SCAN?[Choose TWO correct options]Note :More than one option can be correct

Question 11What does this code do?12345678SELECT e.employee_id, e.first_name, e.last_name, e.salaryFROM employees eWHERE e.salary > (  SELECT AVG(salary)  FROM employees  WHERE department_id = e.department_id); 1 pointIt finds employees who earn more than the average salary in their department.It calculates the average salary for all employees.It groups employees by department.It joins the employees table with itself.

A table occupies 3000 blocks. FlightNumber is the primary key. A single-level index on FlightNumber occupies 100 blocks. The WHERE clause of a SELECT specifies "FlightNumber = 3750".What is the maximum number of blocks necessary to process the SELECT with an index scan?

Find the following table EmployeeDetails, with the attributes EmployeeID, EmpName, Designation, Salary, DeptNo. You are assigned to a task of providing the solution to the operations department by writing the query which displays the employeeID and the Designation of all the employees whose Salaries are more than the Salary of employees designated as ManagerC

Write queries for the following tables:T1 ( Empno, Ename , Salary, Designation)T2 (Empno, Deptno.)(1) Display the Deptno in which Employee Seeta is working.(2) Display Empno, Ename, Deptno.

In a table Employee with columns EmployeeID, Email, and PhoneNumber, which of the following could be considered a candidate key?