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.
Why E is wrong?
Grant will fulfil the E’s request.
I agree with both below posts, the combination of grant to another schema object and synonym pointing to this object is very common practice. It’s much more useful than reasons matched in B and C, although they are ok as well. Not a very good question this one.
I think that E is the answer too and it is more important