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 20 votes
50%
B 13 votes
50%
C 4 votes
50%
D 13 votes
50%
E 15 votes
50%
Discussions
0 / 1000
maja.veleva
9 months, 1 week 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
8 months, 1 week ago

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

0
palanipsb
7 months, 3 weeks ago

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

0
manjari
5 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
Antolina
1 month, 3 weeks ago

A and e is true

0