The syntax to create a synonym is:CREATE [PUBLIC] synonym_nameFOR [sch – McqOptions

MCQOPTIONS

1.	The syntax to create a synonym is:CREATE [PUBLIC] synonym_nameFOR [schema.]object_name[@database_link_name];In this syntax what specifies either a table, view, sequence, materialized view, type, procedure, function or package as appropriate?
A.	PUBLIC
B.	Synonym_name
C.	Schema
D.	Object_name
Answer» E.

Discussion

No Comment Found

Related MCQs

Select the correct SQL statement.
Abbreviate the term OUI?
Which view lists all database links in the database?
Which methods are available for authenticating database administrators?
How many tasks present a prioritized approach for designing, implementing, and maintaining an Oracle Database in a Database Administrator?
Which system privileges in the Administration Privileges allows access to a database instance even when the database is not open and the control of these privileges is totally outside of the database itself?
1. Which administrator's responsibilities can include the following tasks?1) Planning for backup and recovery of database information2) Maintaining archived data on tape3) Backing up and restoring the database4) Contacting Oracle for technical support
Select the correct query to view the links that you own.
Which Release number represents a major new version of the software that contains significant new functionality?
Which method is used by the clients to connect to the oracle database server?