Which of the below queries displays employees' name and new salary after the increment of 1000? SELECT ename, sal FROM emp;SELECT ename, sal=sal+1000 FROM emp;SELECT ename, sal+1000 FROM emp;SELECT ename, 1000 FROM emp;

Consider a table Emp(Name, Salary)SELECT Name FROM Emp WHERE Salary BETWEEN 1000 AND 2000;The above query will display the names from the Emp table whose __________Salary is >1000 and Salary <= 2000Salary is >=1000 and Salary <= 2000Salary is >=1000 and Salary < 2000Salary is >1000 and Salary < 2000

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.

Examine the structure of employee table. You issue the following query:DECLAREl_vc_firstname employee.emp_name%type;l_salary employee.salary%type;BEGINSELECT emp_name, salary INTO l_vc_firstname, l_salary FROM employee WHERE emp_id=201;dbms_output.put_line('Number of rows processed: '||sql%rowcount);END;/What will be the outcome of above query?

Which of the following SQL statements can extract employee name’s whose salary is $10000 or higher from the table “human_resource”? SELECT employee_name, COUNT(*) FROM human_resourceWHERE salary>=10000 GROUP BY employee_nameSELECT employee_name FROM human_resourceWHERE salary>=10000SELECT employee_name, salary FROM human_resourceGROUP BY salary HAVING COUNT(*)>=10000SELECT salary FROM human_resourceWHERE employee_name >=10000 GROUP BY salary

employee_id Name Salary1001 Annie 60001009 Ross 45001018 Zeith 7000above are the Employee table details.select employee_id from employee order by employee_id desc;Which of the following output will be true?