Multiple choice technology databases

Which of the following are NOT the authorized operations of SYSOPER

  1. CREATE SPFILE

  2. CREATE DATABASE

  3. ALTER DATABASE OPEN

  4. STARTUP
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SYSOPER administrative privilege in Oracle databases permits basic operations like STARTUP, SHUTDOWN, and MOUNT/OPEN/CLOSE of a database. However, database creation requires the more powerful SYSDBA privilege.

Keep practicing — related questions