100%(3)3 out of 3 people found this document helpful
This preview shows page 1 - 4 out of 14 pages.
Question Complete1Mark 1.00 out of1.00Question Complete2Mark 1.00 out of1.00Started onThursday, 2 August 2018, 2:41 PMStateFinishedCompleted onThursday, 2 August 2018, 3:16 PMTime taken34 mins 50 secsGrade41.00out 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_idAngelica 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?
Question Complete3Mark 0.00 out of1.00Question Complete4Mark 0.00 out of1.00Question Complete5Mark 1.00 out of1.00You 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;