Programming.docx - c SELECT(ONHAND-5 5 WAREHOUSE PROG-113A-LAB-1812S(47\/50 Week 10 Quarterly Examination First Quarter Exam DESCRIPTION FROM PARTS d

Programming.docx - c SELECT(ONHAND-5 5 WAREHOUSE...

This preview shows page 1 - 3 out of 14 pages.

PROG-113A-LAB-1812S / (47/50)► Week 10: Quarterly Examination / ► First Quarter Exam Question 1 Answer saved Marked out of 1.00 Remove flag Question text You can relate data to multiple tables using a foreign key. Select one:TrueFalse Question 2 Answer saved Marked out of 1.00 Remove flag Question text Which of the following SELECT statement is the correct report that will deduct 5 from ONHAND, multiply 5 in WAREHOUSE, after getting the value on both ONHAND and WAREHOUSE add their data: as shown below: ONHAND - 5 + 5 * WAREHOUSE Note that you have to force the Oracle to prioritize first the Subtraction over Multiplication. List only the column DESCRIPTION, ONHAND and WAREHOUSE. Select one: a. SELECT (ONHAND-5) + 5(* WAREHOUSE), b. SELECT ONHAND-5 + 5 * WAREHOUSE, DESCRIPTION FROM PARTS; DESCRIPTION FROM PARTS; c. SELECT (ONHAND-5) + 5 * WAREHOUSE, DESCRIPTION FROM PARTS; d. SELECT ONHAND-5 + 5 (* WAREHOUSE), DESCRIPTION FROM PARTS; Question 3 Answer saved Marked out of 1.00 Flag question Question text INSERT, DELETE, UPDATE are ________________ commands Select one: Question 4 Answer saved Marked out of 1.00 Flag question Question text What will be the SQL command if every employee will be given a productivity bonus which is equivalent to 3% of the monthly salary?Display the employee id, salary and the productivity bonus.Select one: FROM employees FROM employees
Image of page 1
FROM employees 03) FROM employees employees WHERE salary) Question 5 Answer saved Marked out of 1.00 Flag question Question text You want to display the employee’s last name whose salary is below 10,000 and whose lastname starts with letter K. Which SQL statement give the required output format of the salary? Select one: '$999,999.99') AS "MONTHLY SALARY" FROM employees WHERE salary < 10000WHERE last_name LIKE ‘K%’ '$999,999.99') AS "MONTHLY SALARY" FROM employees WHERE salary < 10,000WHERE last_name = ‘K%’ $999,999.99) AS "MONTHLY SALARY" FROM employees WHERE salary < 10000 WHERE last_name IN 'K%' '$999,999.99') AS "MONTHLY SALARY" FROM employees WHERE salary < 10,000 WHERE last_name STARTS 'K%' Question 6 Answer saved Marked out of 1.00 Remove flag Question text Which of the following is the correct report that will display the CLASS from table PARTS.
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture