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?

Question

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.

• A
  77% (30)
• B
  13% (5)
• C
  3% (1)
• D
  8% (3)

No community discussion yet for this question.