1z0-071 question 378 discussion

View all Oracle Database SQL Exam here
back to oracle forum

Question 378

Which two statements are true about Oracle synonyms? (Choose two.)

  • A. A synonym can have a synonym. Most Votes
  • B. All private synonym names must be unique in the database.
  • C. Any user can create a PUBLIC synonym.
  • D. A synonym can be created on an object in a package.
  • E. A synonym has an object number. Most Votes
Answer:

B D


Explanation:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm

User Votes:
A 16 votes
50%
B 10 votes
50%
C 4 votes
50%
D 11 votes
50%
E 12 votes
50%
Discussions
0 / 1000
maja.veleva
7 months, 2 weeks ago

A is correct because - CREATE SYNONYM statement creates 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.

0
mdas
6 months, 2 weeks ago

A, E looks valid. Each objects in the Oracle database has an object_id (reffer to dba_objects). A is obvious.

0
palanipsb
5 months, 3 weeks ago

Each objects in the Oracle database has an object_id (reffer to dba_objects). A is obvious.

0
manjari
3 months ago

D is incorrect because The schema object cannot be contained in a package.
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm

0