Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

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

Cora

2 days 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

...

Jackie

4 days 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

...

Kathrine

11 days ago

A, B, and E seem like the correct answers, but I'm not sure about CREATE DATABASE. Isn't that a bit too powerful for a SYSOPER user?

upvoted 0 times

...

Patria

12 days ago

I'm not sure about CREATE DATABASE and DROP DATABASE, but I think the correct answers are A) STARTUP, B) SHUTDOWN, and E) ALTER DATABASE RECOVER.

upvoted 0 times

...

Sylvia

13 days ago

I agree with Tu, but I also think they can perform ALTER DATABASE RECOVER.

upvoted 0 times

...

Tu

14 days ago

I think the PUBLIC user with SYSOPER privilege can perform STARTUP and SHUTDOWN.

upvoted 0 times

...

Lavelle

16 days ago

I believe the third operation could be ALTER DATABASE RECOVER. It's important for maintaining database integrity.

upvoted 0 times

...

Magnolia

20 days ago

I agree with Alaine. Those are essential operations for managing the database.

upvoted 0 times

...

Alaine

20 days ago

I think the PUBLIC user with SYSOPER privilege can do STARTUP and SHUTDOWN.

upvoted 0 times

...

az-700 pass4success az-104 200-301 200-201 cissp 350-401 350-201 350-501 350-601 350-801 350-901 az-720 az-305 pl-300

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77