What are two reasons to create synonyms? (Choose two.)
A.
You have too many tables.
B.
Your tables names are too long.
C.
Your tables have difficult names.
D.
You want to work on your own tables.
E.
You want to use another schema’s tables.
F.
You have too many columns in your tables.
Explanation:
Create a synonyms when the names of the tables are too long or the table names are difficult.
Incorrect answers:
A:
The number of tables in a schema is not a consideration when creating a synonym.
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 12-24
Hmm … I’d possibly consider answer E an option too.
That is pretty much the only reason I ever used a synonym.
Though you do have to still grant/have the required permissions so not sure.