Login to your TITANAUTIO pluggable database. Run the attached PROJECT5.TXT file. Create a VIEW called EMP_ADDRESS on EMP

[answerhappygod]

Login to your TITANAUTIO pluggable database. Run the attachedPROJECT5.TXT file.
Create a VIEW called EMP_ADDRESS on EMP_DATA that incorporatesONLY, emp_id, emp_fname, emp_lname, emp_street, emp_street2,emp_city, emp_state, emp_zip and emp_phone (20 points)
Create a local account CLombardo in your TITANAUTIO pluggabledatabase (5 points)
Grant CLombardo the ability to logon to TITANAUTO and to selectfrom EMP_ADDRESS (5 points)
Logon to TITANAUTO as Clombardo and select all records fromEMP_ADDRESS (10 points)
Select all records from EMP_DATA. What happened? Why? (25points)