Practice 1 to 15 And Answers - Practice 1 Answers 1....

Practice 1 Answers
1. Initiate a SQL* Plus session using the user ID and password provided by the instructor.
2. SQL* Plus commands access the database
3. Will the SELECT statement execute successfully?
4. Will the SELECT statement execute successfully? 5. There are four coding errors in this statement. Can you identify them?
"
6. Show the structure of the DEPT table. Select all data from the DEPT table.
7. Show the structure of the EMP table. Create a query to display the name, job, hire date,
and employee number for each employee, with employee number appearing first. Save you
SQL statement to a file named p1q.sql.

desc emp
SELECT empno, ename,
job, hiredate
FROM emp
8. Run your query in the file p1q7.sql.
9. Create a query to display unique jobs from the EMP table.
10. Load plq7.sql into the SQL buffer. Name the column headings Emp#. Employee, Job
and Hire Date, Respectively. Return your query. 11. Display the name concatenated with the job, separated by a comma and space, and name
the column: Employee and Title.
SELECT ename||', '||job "Employee and Title"
FROM emp
If you want extra challenge, complete the following exercise:
12. Create a query to display all the data from the EMP table. Separate each column by a
comma. Name the column THE_OUTPUT.
SELECT empno || ',' || ename || ','|| job || ',' ||
mgr || ',' || hiredate || ',' || sal || ',' ||
comm || ',' || deptno THE_OUTPUT
FROM emp

Practice 2
Answers
1. Create query to display the name and salary of employees earning more than $2850. Save
your SQL statement to a file named p2ql.sql. Run your query.
2. Create a query to display the employee name and department number for employee
number 7566.
3. Modify p2ql.sql to display the name and salary for all employees whose salary is not in the
range of $1500 and $2850. Resave your SQL statement to a file named p2q3.sql. Rerun your
query.
4. Display the employee name, job, and start date of employees hired between February 20,
1981 and May 1, 1981. Order the query in ascending order by start date.
5. Display the employee name and department number of all employees in departments 10
and 30 in alphabetical order by name.

6. Modify p2q3.sql to list the name and salary of employees who earn more than $1500 and
are in department 10 or 30. Label the columns Employee and Monthly Salary respectively.