Oracle
1Z0-063 · Question #163
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…
The correct answer is C. because the threaded architecture requires authentication using a password file before issuing a. See the full explanation below for the reasoning.
Question
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?
Options
- Abecause the threaded architecture requires exiting from sqlpIus and reconnecting with sqlPIus /
- Bbecause the threaded architecture requires issuing a new connect / as sysdba from within
- Cbecause the threaded architecture requires authentication using a password file before issuing a
- Dbecause the threaded architecture requires connecting to the instance via a listener before
- Ebecause the threaded architecture requires restarting the listener before issuing a startup
How the community answered
(33 responses)- B3% (1)
- C82% (27)
- D6% (2)
- E9% (3)
Community Discussion
No community discussion yet for this question.