Oracle
1Z0-144 · Question #96
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…
The correct answer is B. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package. See the full explanation below for the reasoning.
Question
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?
Exhibits
Options
- AIt drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.
- BIt drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.
- CIt returns an error and does not drop the MAMAGE_EMP package because of the cascading
- DIt drops the MANAGE_EMP package and invalidates both the specification and body for the
How the community answered
(37 responses)- A3% (1)
- B76% (28)
- C8% (3)
- D14% (5)
Community Discussion
No community discussion yet for this question.