Which of the following SQL command will satisfy the requirements Select one a

Which of the following sql command will satisfy the

This preview shows page 16 - 20 out of 96 pages.

Which of the following SQL command will satisfy the requirements? Select one: a. UPDATE first_name = ‘David’ AND last_name = ‘Austin’ FROM employees SET department_id = 30 b. UPDATE department_id = 30 WHERE first_name = ‘David’ AND last_name = ‘Austin’ c. UPDATE employees WHERE department_id = 30 SET first_name = ‘David’ AND last_name = ‘Austin’ d. UPDATE employees SET department_id = 30 WHERE first_name = ‘David’ AND last_name = ‘Austin’ Question 11 Complete Mark 2.00 out of 2.00 Flag question Question text John want to know how many employees receiving salary below 10,000. What SQL command he need to run? Select one: a. SELECT COUNT(*) FROM employees WHERE salary < 10000;
Image of page 16
b. SELECT COUNT(salary) FROM employees WHERE salary < 10,000; c. SELECT COUNT(emp_id) FROM employees WHERE salary <= 10000; d. SELECT salary FROM COUNT(employees)WHERE salary < 10000; Question 12 Complete Mark 2.00 out of 2.00 Flag question Question text Evaluate the following SQL command SELECT employee_id, salary, department_id FROM employees WHERE department_id IN (60,70) Select one: a. The SQL command will produce an error. b. The SQL command will display employees with department id 60 and 70. c. The SQL command will give an incorrect output. d. The SQL command will display employees with department id 60 or 70. Question 13 Complete Mark 2.00 out of 2.00 Flag question Question text You want to display the employee's last name and date hired in year 2000 to2006 whose salary is above 5000. Which SQL statement give the required output? Select one: a. SELECT last_name, hire_date FROM employees WHERE hire_date>= TO_DATE('01-Jan-2006', 'DD-Mon-RR') AND hire_date<= TO_DATE('31-Dec-2006', 'DD-Mon-RR') AND salary > 5000; b. SELECT last_name, hire_date FROM employees WHERE hire_date>= TO_DATE('Jan-2000', 'Month-YYYY') AND hire_date<= TO_DATE('Dec-2006', 'Month- ‘YYYY') AND salary > 5,000; c. SELECT last_name, hire_date FROM employees WHERE hire_date>= TO_DATE('01-Jan-2000', 'DD-Mon-YYYYY') AND hire_date<= TO_DATE('31-Dec-2006', 'DD-Mon- YYYY') AND salary ABOVE 5000; d. SELECT last_name, hire_date FROM employees WHERE hire_date>= TO_DATE('2000', 'YYYY') AND hire_date<= TO_DATE('2006', 'YYYY') OR salary > 5000;
Image of page 17
Question 14 Complete Mark 2.00 out of 2.00 Flag question Question text List all employees except for IT_PROG job id. Select one: a. SELECT *FROM employees EXCEPT JOB_ID != 'IT_PROG' b. SELECT *FROM employees WHERE JOB_ID NOT IN ('IT_PROG') c. SELECT *FROM employees WHERE JOB_ID <> 'IT_PROG' d. All of the choices Question 15 Complete Mark 2.00 out of 2.00 Flag question Question text Evaluate the following SQL command SELECT employee_id, min_salary, max_salary FROM employees, departments WHERE salary>= 10000 && salary <= 20000 Select one: a. The SQL will produce Cartesian Product b. The SQL will display the employee id, department id and the minimum and maximum salary whose salary is between 10000 and 20000. c. The SQL command will produce an error. d. The SQL command will give an incorrect output. Question 16 Complete Mark 2.00 out of 2.00 Flag question Question text
Image of page 18