Scribd
Upload
122 views1 page

SQL Practice Solutions Guide

This document provides solutions to practice problems for an Oracle SQL tutorial. It walks through executing sample SELECT statements on database tables, identifying errors in a SQL statement, describing the structure of tables, and saving and running SQL queries from files.

Uploaded by

Anas Ahmad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
122 views1 page

SQL Practice Solutions Guide

This document provides solutions to practice problems for an Oracle SQL tutorial. It walks through executing sample SELECT statements on database tables, identifying errors in a SQL statement, describing the structure of tables, and saving and running SQL queries from files.

Uploaded by

Anas Ahmad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Practice 1 Solutions

1. Initiate an iSQL*Plus session using the user ID and password provided by the instructor.
2. iSQL*Plus commands access the database.
False
3. The following SELECT statement executes successfully:
True
SELECT last_name, job_id, salary AS Sal
FROM employees;
4. The following SELECT statement executes successfully:
True
SELECT *
FROM job_grades;
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;
– The EMPLOYEES table does not contain a column called sal. The column is called
SALARY.
– The multiplication operator is *, not x, as shown in line 2.
– The ANNUAL SALARY alias cannot include spaces. The alias should read
ANNUAL_SALARY or be enclosed in double quotation marks.
– A comma is missing after the column, LAST_NAME.
6. Show the structure of the DEPARTMENTS table. Select all data from the DEPARTMENTS table.
DESCRIBE departments
SELECT *
FROM departments;
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. Save
your SQL statement to a file named lab1_7.sql.
DESCRIBE employees
SELECT employee_id, last_name, job_id, hire_date
FROM employees;
Introduction to Oracle9i: SQL A-4
Practice 1 Solutions (continued)
8. Run your query in the file lab1_7.sql.
SELECT employee_id, last_name, job_id, hire_date
FROM employees;
9. Create a query to display unique job codes from the EMPLOYEES table.
SELECT DISTINCT job_id
FROM employees;
If you have time, complete the following exercises:
10. Copy the statement from lab1_7.sql into the iSQL*Plus Edit window. Name the column
headings Emp #, Employee, Job, and Hire Date, respectively. Run your query again.
SELECT employee_id "Emp #", last_name "Employee",
job_id "Job", hire_date "Hire Date"
FROM employees;

You might also like