Lab01 (20 points) Preliminary Login into Linux machine (oraclelinux.eng.fau.edu) .Connect to database (e.g., sqlplus username/password) ALTER SESSION SET CURRENT SCHEMA YANGK Change line size: SET LINESIZE 400 . There are 6 tables: TITLES, SALARIES, EMPLOYEES, DEPT MANAGER, DEPT EMP, and DEPARTMENTS .Execute the f g SOL and review the SELECT cols.table name |I' ll cols.column_name II Il cons.owner FROM WHERE cons.constraint type 'P AND AND ORDER BY cols.table name, cols.position; all constraints cons, all cons columns cols cons.constraint name- cons.owner- "YANGK name Execute the f SQL and review the indexed k SELECT table name l index_name II lcolumn_ name IIl column position FROM WHERE table owner YANGK ORDER BY index name. column all ind columns Execute the following SQL and review the index structure. SELECT index_name IIindex typel 11 blevel II leaf blocks II l table name l avg leaf blocks per key II 'Il avg_data blocks per key II 'll clustering factor |l', ll distinct keys FROM all indexes WHER Query Evaluation . Use Spool command to log the output of SOL (e.g., SPOOL filename and SPOOL OFF .Use AUTOTRACE command to see Execution Plans for SQL statements (i.e.,set autotrace traceonly explain) There are two files you should submit: 1) explanation for query execution plans and 2) recorded spool file. Lab01 (20 points) Preliminary Login into Linux machine (oraclelinux.eng.fau.edu) .Connect to database (e.g., sqlplus username/password) ALTER SESSION SET CURRENT SCHEMA YANGK Change line size: SET LINESIZE 400 . There are 6 tables: TITLES, SALARIES, EMPLOYEES, DEPT MANAGER, DEPT EMP, and DEPARTMENTS .Execute the f g SOL and review the SELECT cols.table name |I' ll cols.column_name II Il cons.owner FROM WHERE cons.constraint type 'P AND AND ORDER BY cols.table name, cols.position; all constraints cons, all cons columns cols cons.constraint name- cons.owner- "YANGK name Execute the f SQL and review the indexed k SELECT table name l index_name II lcolumn_ name IIl column position FROM WHERE table owner YANGK ORDER BY index name. column all ind columns Execute the following SQL and review the index structure. SELECT index_name IIindex typel 11 blevel II leaf blocks II l table name l avg leaf blocks per key II 'Il avg_data blocks per key II 'll clustering factor |l', ll distinct keys FROM all indexes WHER Query Evaluation . Use Spool command to log the output of SOL (e.g., SPOOL filename and SPOOL OFF .Use AUTOTRACE command to see Execution Plans for SQL statements (i.e.,set autotrace traceonly explain) There are two files you should submit: 1) explanation for query execution plans and 2) recorded spool file