Oracle Database 12c: SQL Fundamentals — Question 51

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

Answer options

• 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.

Correct answer: B, C

Explanation

Creating synonyms can simplify the use of tables with long or complex names, making them easier to reference. Therefore, options B and C are valid reasons, while options A, D, E, and F do not directly address the need for synonyms.