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 18 votes
50%
B 12 votes
50%
C 4 votes
50%
D 11 votes
50%
E 14 votes
50%
Discussions
0 / 1000
maja.veleva
8 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
7 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
6 months, 4 weeks ago

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

0
manjari
4 months, 1 week 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
4 weeks, 1 day ago

A and e is true

0