Exam 1z0-082 topic 1 question 78 discussion

Actual exam question from Oracle's 1z0-082

Question #: 78
Topic #: 1

[All 1z0-082 Questions]

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

A. A synonym cannot be created for a PL/SQL package
B. A synonym can be available to all users
C. A SEQUENCE can have a synonym
D. A synonym created by one user can refer to an object belonging to another user
E. Any user can drop a PUBLIC synonym

Show Suggested Answer

Suggested Answer: BCD 🗳️
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm

by you1234 at June 30, 2020, 8:56 a.m.

Comments

Submit Cancel

NiciMilo

Highly Voted 2 years, 11 months ago

B, C and D

upvoted 20 times

Ekos

2 years, 7 months ago

i agree, B, C, and D is the correct answer

upvoted 2 times

...

Kuraudio

Most Recent 7 months, 2 weeks ago

Selected Answer: BCD

BCD is correct

upvoted 1 times

...

LeandroHPN

1 year ago

B , C , D is correct

upvoted 1 times

...

Mandar79

2 years, 10 months ago

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm Public synonyms are accessible to all users.

upvoted 1 times

...

https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9002.htm#SQLRF01805 To drop a private synonym, either the synonym must be in your own schema or you must have the DROP ANY SYNONYM system privilege. To drop a PUBLIC synonym, you must have the DROP PUBLIC SYNONYM system privilege.

upvoted 2 times

...

ama

3 years ago

E is wrong!!!!!!!!!!! To drop a PUBLIC synonym, you must have the DROP PUBLIC SYNONYM system privilege

upvoted 3 times

...

you1234

3 years ago

B & D & E is correct answer

upvoted 2 times

...