For the Oracle tables you created and stored in the Lab exercise complete the following: Log on the Oracle server and start up SQLPLUS- as we have…

For the Oracle tables you created and stored in the Lab exercise complete the following:

Log on the Oracle server and start up SQLPLUS, as we have done in class.

Enter the following commands. The first will print out the data in your tables. The second will printout the SQL queries and the results.

1.Select *

FromConsultant;

Select *

FromClient;

Select *

FromAudit_T;

Select *

FromAudit_Consultant;

Select *

FromZipcode;

2.Add a column to the Consultant table called “Manager” defined as varchar2 for a length of 20.

Update the new field with whatever data you choose, i.e. you can use the same value in all rows if

​like.

Add your own name to the Consultant table, use an existingzipcodeto avoid having to add a new

​one.

3.Write SQLcommands to answer the following questions:

Explanation & Answer

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.