Oracle Database Fundamental I
Practice 1 Solutions
(Questions 1 to 5 just true and false, So try itself)
Solutions: Structure- desc departments;
Contents– select * from departments;
7. You need to determine the structure of the EMPLOYEES table.
Solutions: desc employees;
8. The HR department wants a query to display the last name, job code, hire date, and employee number for each employee, with employee number appearing first. Provide an alias STARTDATE for the HIRE_DATE column. Save your SQL statement to a file named lab_01_07.sql so that you can disperse this file to the HR department.
Solutions: select employee_id, last_name, job_id, hire_date startdate
9. The HR department needs a query to display all unique job codes from the EMPLOYEES table.
Solutions: select distinct job_id
10. The HR department wants more descriptive column headings for its report on employees. Copy the statement from lab_01_07.sql to the iSQL*Plus text box. Name the column headings Emp #, Employee, Job, and Hire Date, respectively. Then run your query again.
Solutions: select employee_id “EmP#”, last_name “Employee”, job_id “Job”, hire_date “Hire Date”
11. The HR department has requested a report of all employees and their job IDs. Display the last name concatenated with the job ID (separated by a comma and space) and name the column Employee and Title.
Solutions: select last_name||’, ‘||job_id “Employee and Title” from employees;
12. To familiarize yourself with the data in the EMPLOYEES table, create a query to display all the data from that table. Separate each column output by a comma. Name the column title THE_OUTPUT.
Solutions: select employee_id||’,’||first_name||’,’|| last_name||’,’||email||’,’||phone_number||’,’||hire_date||’,’||job_id||’,’||salary||’,’||commission_pct the_output from employees;