Creating a __________ eliminate the need to qualify the object name with the schema and provides you with an alternative name for a table, view, sequence, procedure or other objects.
Creating a __________ eliminate the need to qualify the object name with the schema and provides you with an alternative name for a table, view, sequence, procedure or other objects.
The correct option is B Synonym
Creating a synonym eliminate the need to
qualify the object name with the schema and provides you with an alternative
name for a table, view, sequence, procedure or other objects.
Use the CREATE synonym statement to create a synonym, which is an alternative name
for a table, view, sequence, operator, procedure, stored function, package,
materialized view, Java class schema object, user-defined object type, or
another synonym. A synonym places a dependency on its target object and becomes
invalid if the target object is changed or dropped.
Synonyms provide both data independence and location
transparency. Synonyms permit applications to function without modification
regardless of which user owns the table or view and regardless of which
database holds the table or view. However, synonyms are not a substitute for
privileges on database objects.
Creating a synonym eliminate the need to qualify the object name with the schema and provides you with an alternative name for a table, view, sequence, procedure or other objects.
Use the CREATE synonym statement to create a synonym, which is an alternative name for a table, view, sequence, operator, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym. A synonym places a dependency on its target object and becomes invalid if the target object is changed or dropped.
Synonyms provide both data independence and location transparency. Synonyms permit applications to function without modification regardless of which user owns the table or view and regardless of which database holds the table or view. However, synonyms are not a substitute for privileges on database objects.
