What are two reasons to create synonyms?

What are two reasons to create synonyms? (Choose two.)

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.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Helcio

Helcio

Why E is wrong?

spellublind

spellublind

Grant will fulfil the E’s request.

Gabriel K

Gabriel K

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.

Jenny

Jenny

I think that E is the answer too and it is more important