Oracle Exam 1Z0-497 Topic 11 Question 76 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 76
Topic #: 11

[All 1Z0-497 Questions]

Which three operations can the PUBLIC user with the SYSOPER privilege perform?

ASTARTUP

BSHUTDOWN

CCREATE DATABASE

DDROP DATABASE

EALTER DATABASE RECOVER

Show Suggested Answer

Suggested Answer: D

https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

by Carin at Jul 08, 2023, 03:11 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Thaddeus

1 months ago

As a SYSOPER user, you're basically the database firefighter. Your job is to keep the lights on, not remodel the house. A, B, and E are the correct answers here.

upvoted 0 times

Rikki

15 days ago

E) ALTER DATABASE RECOVER

upvoted 0 times

...

Thea

21 days ago

B) SHUTDOWN

upvoted 0 times

...

Fernanda

22 days ago

A) STARTUP

upvoted 0 times

...

Cora

2 months ago

I agree with Kathrine and Jackie. A, B, and E are the three operations a SYSOPER user can perform. Trying to CREATE or DROP a database is probably a trap answer.

upvoted 0 times

Malissa

5 days ago

Definitely, A, B, and E are the safe options for a SYSOPER user.

upvoted 0 times

...

Lindsey

6 days ago

Yes, I agree. Creating or dropping a database seems too risky.

upvoted 0 times

...

Samuel

7 days ago

I think A, B, and E are the correct operations for a SYSOPER user.

upvoted 0 times

...

Jackie

2 months ago

Hmm, I thought SYSOPER could only perform operations related to starting, shutting down, and recovering the database. CREATE and DROP DATABASE sound like admin-level privileges to me.

upvoted 0 times

...