ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam
Go to Exam

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
NiciMilo
Highly Voted 2 years, 8 months ago
B, C and D
upvoted 20 times
Ekos
2 years, 4 months ago
i agree, B, C, and D is the correct answer
upvoted 2 times
...
...
Kuraudio
Most Recent 4 months, 2 weeks ago
Selected Answer: BCD
BCD is correct
upvoted 1 times
...
LeandroHPN
9 months, 2 weeks ago
B , C , D is correct
upvoted 1 times
...
Mandar79
2 years, 7 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
...
Mandar79
2 years, 7 months ago
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
2 years, 9 months ago
E is wrong!!!!!!!!!!! To drop a PUBLIC synonym, you must have the DROP PUBLIC SYNONYM system privilege
upvoted 3 times
...
you1234
2 years, 9 months ago
B & D & E is correct answer
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago