Select one a List of employees name salary and department name b Cartesian

Select one a list of employees name salary and

This preview shows page 76 - 79 out of 82 pages.

Select one: a. List of employees name, salary and department name b. Cartesian Product c. Results to invalid SQL command d. Results to invalid relational operator e. Display a full outer join Question 5 Incorrect Mark 0.00 out of 1.00 Flag question Question text Update the Purchasing department name to Procurement. And this will be managed by the Manager of Administration department. Select one: a. UPDATE FROM departments SET department_name = 'Procurement' AND manager_id = 200 WHERE department_name = 'Purchasing' b. UPDATE departments SET department_name = 'Procurement', manager_id = 200 WHERE department_name = 'Purchasing' c. UPDATE * FROM departments SET department_name = 'Procurement', SET manager_id = 200 HAVING department_name = 'Purchasing'
Image of page 76
d. UPDATE departments_name FROM departments SET department_name = 'Procurement', SET manager_id = 200 WHERE department_name = 'Purchasing' Question 6 Incorrect Mark 0.00 out of 1.00 Flag question Question text Display all the employee id, names of employees ,job id and department nameof all employees of the Finance Department. Select one: a. SELECT first_name, last_name, job_id, department_name FROM employees JOIN department ON (department_id) WHERE department_name = 'Finance' b. SELECT A.first_name, A.last_name, A.job_id, B.department_name FROM employees A JOIN departments B ON ( A.department_id = B.department_id) WHERE B.department_name = 'Finance' c. SELECT A.first_name, A.last_name, A.job_id, B.department_name FROM employees A INNER JOIN departments B ON ( A.department_id = B.department_id) ON B.department_name = 'Finance' d. All of the choices Question 7 Correct Mark 1.00 out of 1.00 Flag question Question text A new department name Training with department id 300 was created in the company. This will be managed by a Manager with ID of 203 and will located at location id 2400. Create a SQL command to update the information in the department table. Select one: a. INSERT INTO departments SET department_id = 300, department_name = 'Training', manager_id = 203, location_id = 2400 b. INSERT FROM departments(department_id, department_name, manager_id, location_id) VALUES (300, 'Training', 203, 2400) c. INSERT INTO departments VALUES (300, 'Training', 203, 2400) d. INSERT * FROM departments VALUES (300, 'Training', 203, 2400) Question 8 Correct Mark 1.00 out of 1.00 Flag question Question text Create a SQL command to add a new position Java Developer with job id of JAVA_DEV whose salary ranges from 7,000 to 8,000. Select one: a. INSERT FROM jobs SET jobs_id = ‘JAVA_DEV’, job_title = ‘Java Developer’ , min_salary =7000 , max_salary= 8000
Image of page 77
b. INSERT * INTO jobs VALUES (JAVA_DEV, Java Developer, 7000, 8000) c. INSERT INTO jobs VALUES ('JAVA_DEV', 'Java Developer', 7000, 8000) d. INSERT FROM jobs(jobs_id, job_title, min_salary, max_salary) VALUES ('JAVA_DEV', 'Java Developer', 7000, 8000) Question 9 Correct Mark 1.00 out of 1.00 Flag question Question text Create a SQL command to add a new position Database Administrator with job id of DB_ADMIN whose salary ranges from 10,000 to 18,000.
Image of page 78
Image of page 79

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture