1. Initiate an iSQL*Plus session using the user ID and password provided by the instructor.

	HR | Your Password

2. iSQL*Plus commands access the database.

	True/False

3. The following SELECT statement executes successfully:

SELECT last_name, job_id, salary AS Sal
  FROM employees;

       True/False

4. The following SELECT statement executes successfully:

SELECT * 
  FROM job_grades;
 
        True/False

5. There are four coding errors in this statement. Can you identify them? 

SELECT employee_id, last_name
   sal x 12 ANNUAL SALARY
 FROM employees;

6. Show the structure of the DEPARTMENTS table. Select all data from the table

7. Show the structure of the EMPLOYEES table. 
   Create 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.
  
   EMPLOYEE_ID LAST_NAME                 JOB_ID     STARTDATE
  ----------- ------------------------- ---------- ---------
        100 King                      AD_PRES    17-JUN-87
        101 Kochhar                   AD_VP      21-SEP-89
        102 De Haan                   AD_VP      13-JAN-93
        103 Hunold                    IT_PROG    03-JAN-90

8. Create a query to display unique job codes from the EMPLOYEES table.


9. Write a query to display alias name for the columns in employee table.
   employee_id as Emp #, Employee, Job, and Hire Date, respectively. 
  
   
      Emp# Employee                  job        HIRE_DATE
---------- ------------------------- ---------- ---------
       100 King                      AD_PRES    17-JUN-87
       101 Kochhar                   AD_VP      21-SEP-89
       102 De Haan                   AD_VP      13-JAN-93
       103 Hunold                    IT_PROG    03-JAN-90
 
10. Display the last name concatenated with the job ID, separated by a comma and space, and name 
the column Employee and Title.

11. Create a query to display all the data from the EMPLOYEES table. Separate each column by a
comma. Name the column THE_OUTPUT