What is synonyms what is use of it?

Question

Accepted Answer

Synonyms are database objects that allow users to create aliases for other database objects.

Synonyms can be used to simplify complex queries by providing a shorter name for a table or view.
They can also be used to provide a layer of abstraction between the user and the underlying database objects.
Synonyms can be created for tables, views, stored procedures, and other database objects.
They can be used to reference objects in other databases or even on other servers.
Synonyms can be useful in situations where database objects are frequently renamed or moved.
They can also be used to provide a level of security by allowing users to access objects without knowing their actual names.

Top AmbitionBox SQL Developer interview questions & answers