1Z0-071 practice question 11 of 35
You have the privileges to create any type of synonym. Which stalement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accesible to all users?
Full set: 326 questionsTo create a synonym that is accessible to all users in the database, you must create a PUBLIC synonym. The correct syntax for this is CREATE PUBLIC SYNONYM synonymname FOR objectname;. Option E uses this exact syntax to create a public synonym named emp for the hcm.employeerecords table. Once created, any user with appropriate privileges on the underlying table can refer to it as emp without needing to specify the hcm schema.
A. GLOBAL is not a valid keyword in the CREATE SYNONYM statement. The syntax is incorrect.
B. This statement creates a private synonym in the current user's schema, which is not accessible to all users by default.
C. This is not the correct syntax. To create a public synonym, the PUBLIC keyword must
1. Oracle Database SQL Language Reference 19c, “CREATE SYNONYM” statement – public synonym syntax (Doc ID: E96306-01, §CREATE SYNONYM).
2. Oracle Database Concepts 19c, “Schema Objects: Synonyms” – visibility rules for public vs. private synonyms (Doc ID: E96299-01, §5.8).
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…
