Practice 1: Overview
This is the first of many practices in this course. Practices are intended to cover all topics that are presented in the corresponding lesson.
Note the following location for the lab files:
E:\labs\SQL1\labs
If you are asked to save any lab files, save them at this location.
To start ISQL*Plus, start your browser. You need to enter a URL to access iSQL*Plus. The URL requires the host name, which your instructor will provide. Enter the following command, replacing the host name with the value that your instructor provides: http://<HOSTNAME:5561>/isqlplus
In any practice, there may be exercises that are prefaced with the phrases “If you have time” or “If you want an extra challenge.” Work on these exercises only if you have completed all other exercises in the allocated time and would like a further challenge to your skills.
Perform the practices slowly and precisely. You can experiment with saving and running command files. If you have any questions at any time, ask your instructor.

Practice 1
Test your knowledge:
1. Initiate an iSQL*Plus session using the user ID and password that are provided by the instructor.
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 the following statement. Can you identify them? SELECT employee_id, last_name sal x 12 ANNUAL SALARY FROM employees;

Practice 2: Overview
In this practice, you build more reports, including statements that use the WHERE clause and the ORDER BY clause. You make the SQL statements more reusable and generic by including ampersand substitution.