What is the difference between PRIVATE AND PUBLIC SYNONYM?

Question

If we delete the base table whether the synonym will exists or not? If we use that synonym what type of error we will get?

Answer 1

Only the user or table owner can reference Private synonym whereas any user can reference the Public synonym.