Oracle Database 12c: Advanced Administration — Question 169

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:

CONNECT/AS SYSDBA -
ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE;

SHUTDOWNIMMEDIATE -
You then restart the instance and get an error:

STARTUP -
ORA-01031:insufficientprivileges
Why does the startup command return the error shown?

Answer options

• A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command
• B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
• C. because the threaded architecture requires authentication using a password file before issuing a startup command
• D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
• E. because the threaded architecture requires restarting the listener before issuing a startup command

Correct answer: C

Explanation

The correct answer is C because the threaded architecture in Oracle requires a password file for authentication when starting the database instance. Options A and B refer to reconnections that are not necessary for this context, while options D and E address listener-related issues that do not pertain to privilege errors.