Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 6 of 40

Marks: +1, -0

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

CONNECT /AS SYSDBA 
 ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE; 
 SHUTDOWN IMMEDIATE

You then restart the instance and get an error:

STARTUP 
 ORA-01031: insufficient privileges

Why does the startup command return the error shown?

because the threaded architecture requires exiting from sql*plus and reconnecting with sql*Plus / as sysdba before issuing a startup command
because the threaded architecture requires issuing a new connect / as sysdba from within sql*plus before issuing a startup command
because the threaded architecture requires authentication using a password file before issuing a startup command
because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
because the threaded architecture requires restarting the listener before issuing a startup command

Go to Question:

Prev Question

Next Question