What is the outcome?

View Exhibit 1 and examine the structure of the EMP table.

View Exhlbit2 and examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

View Exhibit 1 and examine the structure of the EMP table.

View Exhlbit2 and examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

A.
It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.

B.
It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

C.
It returns an error and does not drop the MAMAGE_EMP package because of the cascading
effect.

D.
It drops the MANAGE_EMP package and invalidates both the specification and body for the
EMP_DET package.



Leave a Reply 6

Your email address will not be published. Required fields are marked *