1Z0-071 practice question 19 of 35
Which two statements are true about Oracle synonyms?
Full set: 326 questionsA synonym is an alias for another schema object. It is possible to create a synonym that points to another synonym, and Oracle will resolve this chain to find the base object (A). Synonyms are schema objects stored in the data dictionary and, as such, are assigned a unique object number (OBJECTID) within the database, which can be queried from views like DBAOBJECTS (E). This confirms they are distinct database objects.
B. Private synonym names must be unique within a schema, not across the entire database. Different users can have private synonyms with the same name.
C. Creating a PUBLIC synonym requires the CREATE PUBLIC SYNONYM system privilege, which is a powerful privilege not granted to users by default.
D. A synonym can be created for a package, but not for a specific procedure, function, or variable within that package.
1. Oracle Database SQL Language Reference, 19c, "CREATE SYNONYM". The documentation notes that object can be a "table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym." This supports option A.
2. Oracle Database Reference, 19c, "Static Data Dictionary Views", Section "DBAOBJECTS". This view description lists SYNONYM as a possible OBJECTTYPE, and the OBJECTID column is described as the "Object number of the object," confirming synonyms have object numbers. This supports option E.
3. Oracle Database Administrator's Guide, 19c, "Managing Users and Security", Section "Managing Privileges and Roles". This guide details system privileges, including CREATE PUBLIC SYNONYM, confirming it is a specific, non-default privilege. This refutes option C.
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 6Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
