Oracle
1Z0-047 · Question #183
1Z0-047 Question #183: Real Exam Question with Answer & Explanation
The correct answer is A. Only the synonym would be dropped.. See the full explanation below for the reasoning.
Question
ORD is a private synonym for the OE.ORDERS table. The user OE issues the following command: DROP SYNONYM ord; Which statement is true regarding the above SOL statement?
Options
- AOnly the synonym would be dropped.
- BThe synonym would be dropped and the corresponding table would become invalid.
- CThe synonym would be dropped and the packages referring to the synonym would be dropped.
- DThe synonym would be dropped and any PUBLIC synonym with the same name becomes invalid.
Community Discussion
No community discussion yet for this question.