Which of the following SQL statements will delete the private synonym named MYSYNON?
A) DROP PRIVATE SYNONYM mysynon;
B) DROP PUBLIC SYNONYM mysynon;
C) DROP SYNONYM mysynon;
D) DELETE PRIVATE SYNONYM mysynon;

Question

Which of the following SQL statements will delete the private synonym named MYSYNON?​
A) ​DROP PRIVATE SYNONYM mysynon;
B) ​DROP PUBLIC SYNONYM mysynon;
C) ​DROP SYNONYM mysynon;
D) ​DELETE PRIVATE SYNONYM mysynon;

Quizplus · Accepted Answer

The correct syntax for deleting a synonym is DROP SYNONYM. The PRIVATE or PUBLIC keyword only specifies the access level of the synonym, but it does not affect the syntax for deleting it. Therefore, the correct statement to delete the private synonym named MYSYNON is DROP SYNONYM mysynon.

Which of the Following SQL Statements Will Delete the Private