exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 134 discussion

Actual exam question from Oracle's 1z0-083
Question #: 134
Topic #: 1
[All 1z0-083 Questions]

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)

  • A. They can view data from any data dictionary view or dynamic performance view.
  • B. They cannot create restore points.
  • C. They cannot drop tablespaces.
  • D. They can create any table.
  • E. They can drop any tablespace.
  • F. They can view data from any user-defined tables.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️

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
RinD
Highly Voted 3 years, 2 months ago
ADE correct https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and-role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7
upvoted 20 times
ErikJanssen
1 year, 4 months ago
Additional also E
upvoted 2 times
...
ErikJanssen
1 year, 4 months ago
I think ACD is correct
upvoted 1 times
...
ErikJanssen
1 year, 4 months ago
I have to correct myself: I agree with ADE too.
upvoted 1 times
...
...
ssseee
Highly Voted 3 years, 1 month ago
agree with ADE. https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and-role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7
upvoted 5 times
...
antonica
Most Recent 3 months, 2 weeks ago
ADE, tested
upvoted 1 times
...
kuvinod29
6 months ago
ADE is the correct answer. Please check below https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dbseg/configuring-privilege-and-role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7
upvoted 1 times
...
12345aws
11 months, 2 weeks ago
ADE - correct answer. Verified
upvoted 1 times
...
_gio_
1 year ago
Selected Answer: AD
Two answers are right, E is not correct because you can't drop all tablespace (system for example can't be drop)
upvoted 2 times
...
Kushal22
1 year, 6 months ago
ADE is correct
upvoted 1 times
...
lakerwhu
1 year, 7 months ago
any tablespace? can drop system tablespace? the question is no enough to precise
upvoted 2 times
...
smartvan
2 years, 8 months ago
Agree with ADE
upvoted 2 times
...
nobody347
2 years, 10 months ago
Agree with ADE. But when I create user with SYSBACKUP privilege. I cannot create table or drop tablespace. it's wierd.
upvoted 2 times
_gio_
1 year ago
Because you miss AS SYSBACKUP on connection (sqlplus user as sysbackup)
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago