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 25 votes
50%
B 17 votes
50%
C 6 votes
50%
D 18 votes
50%
E 24 votes
50%
Discussions
0 / 1000
maja.veleva
1 year, 1 month 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
1 year ago

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

0
palanipsb
11 months, 3 weeks ago

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

0
manjari
9 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
5 months, 3 weeks ago

A and e is true

0
dan1234
2 months ago

no doubt about AE

0
pseisog
1 week, 6 days ago

A and E are the correct

0
pratikbedase678
5 days, 12 hours ago

I thinkkkkknb

0