PROG-113A-First-Quarter-Exam.pdf - Started on Thursday 2 August 2018 2:41 PM State Finished Completed on Thursday 2 August 2018 3:16 PM Time taken 34

PROG-113A-First-Quarter-Exam.pdf - Started on Thursday 2...

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

Question Complete 1 Mark 1.00 out of 1.00 Question Complete 2 Mark 1.00 out of 1.00 Started on Thursday, 2 August 2018, 2:41 PM State Finished Completed on Thursday, 2 August 2018, 3:16 PM Time taken 34 mins 50 secs Grade 41.00 out of 50.00 ( 82 %) Display employee's name and id whose firstname starts with letter D and job id isIT_PROG. Sort the output by department. Select one:a. SELECT employees FROM employee_id, first_name, last_name WHEREfirst_name LIKE ‘D%’ and job_id = ‘IT_PROG’ ORDER BY department_idb. SELECT employee_id, first_name, last_name FROM employees WHEREjob_id = 'IT_PROG' OR first_name LIKE 'D%' and ORDER BY department_idc. SELECT employee_id, first_name, last_name FROM employees ORDERBY department_id WHERE first_name LIKE 'D%' and job_id = 'IT_PROG'd. SELECT employee_id, first_name, last_name FROM employees WHEREfirst_name LIKE 'D%' and job_id = 'IT_PROG' ORDER BY department_id Angelica is the Oracle Database Administrator. She was been assigned to create anaccess for the newly hired employee named Matt to the Oracle Database. Which of the following SQL command Angelica will execute?
Image of page 1
Question Complete 3 Mark 0.00 out of 1.00 Question Complete 4 Mark 0.00 out of 1.00 Question Complete 5 Mark 1.00 out of 1.00 You want to display the employee's id and formatted date hired as shown below. Which SQL statement give the required output? You want to cancel the privilege of matt to add records from the employees table. Which of the following SELECT statement is the correct report that will rename thecolumn DESCRIPTION to TITLE, PARTNUM to ID and ONHAND to STOCK? Select one:a. SELECT DESCRIPTION AS TITLE, PARTNUM AS ID, ONHAND AS STOCKFROM PART;b. SELECT DESCRIPTION NEW AS TITLE, PARTNUM NEW AS ID, ONHANDNEW AS STOCK FROM PARTS;c. SELECT DESCRIPTION RENAME AS TITLE, PARTNUM RENAME AS ID,ONHAND RENAME AS STOCK FROM PARTS;d. SELECT DESCRIPTION AS 'TITLE', PARTNUM AS 'ID', ONHAND AS'STOCK' FROM PARTS;
Image of page 2
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture