Question: Lab (50 points) Preliminary Login into Linux machine (oraclelinux.eng.fau.edu) Connect to database (e.g., sqlplus username/password) ALTER SESSION SET CURRENT SCHEMAksyang Execute the following

 Lab (50 points) Preliminary " Login into Linux machine (oraclelinux.eng.fau.edu) "

Lab (50 points) Preliminary " Login into Linux machine (oraclelinux.eng.fau.edu) " Connect to database (e.g., sqlplus username/password) ALTER SESSION SET CURRENT SCHEMAksyang Execute the following SQL and identify all required tables SELECT table name from all tables where owner = 'KSYANG -" Change line size: SET LINESIZE 400 - Use Spool command to create log file for the output of SQL (e.g., SPOOL filename and SPOOL OFF) " Consider the following relational schema fhame CHARACTER VARYING name CHARACTER VARYING(S) works_on CHARACTER) bdate DATE atdress CHARACTER VARYINO 50) CHARACTER DATE dept locations salary NUMERIC pname CHARACTER VARYIN05) areta nd ae DATE plecation CHARACTER VARYINO(S) Write SQL statements for the following queries 1) (10 points) Retrieve essns of employees who worked more than 45 hours on projects 2) (10 points) Retrieve fnames of employees who have no working experience 3) (10 points) Retrieve fnames of employees who have the highest salary 4) (10 points) Retrieve the minimum, maximum and average salaries of employees whose department is 'Research' 5) (10 points) Retrieve fnames of employees who have more than two dependents

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!