Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Practice

(You may use the table relationship diagram in Figure 1.11 with these questions.)

1:	Identify the tables to which you have access.
2:	Identify the name of the columns in the Employee table.
3:	Retrieve the employee department, last name, first name, and current position.
4:	Retrieve the same columns as those in question 3, but combine the Last Name and First Name columns. Preface each name with Mr.
5:	Compute the future wages for each employee if he or she receives a 6-percent raise, a bonus of $2,300, and a deduction of $250 for charity.
6:	Retrieve all of the employees in the database, and display their first and last names. Order the employees by department.
7:	Retrieve all of the employees in the database, and display their first and ...