Exam 1z0-062 topic 2 question 17 discussion

Actual exam question from Oracle's 1z0-062

Question #: 17
Topic #: 2

A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to 400 and make it persistent for your database instance.
You plan to use the ALTER SYSTEM command.
Which two methods can be used? (Choose two.)

A. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.
B. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.
C. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.
D. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.
E. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.
F. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

Show Suggested Answer

Suggested Answer: CF 🗳️

by sherifelia at Nov. 14, 2019, 9:41 a.m.

Comments

Submit Cancel

sherifelia

Highly Voted 5 years, 8 months ago

AB is correct

upvoted 14 times

PaoloBL

3 years, 11 months ago

A is correct B works for sure but you should bounce again the db

upvoted 1 times

...

taiyang

Highly Voted 5 years, 4 months ago

AB is correct, too. D is wrong, because scope = [both/memory/spfile]. The DEFERRED is other option. You must specify DEFERRED if the value of the ISSYS_MODIFIABLE column of V$PARAMETER for this parameter is DEFERRED. If the value of that column is IMMEDIATE, then the DEFERRED keyword in this clause is optional. If the value of that column is FALSE, then you cannot specify DEFERRED in this ALTER SYSTEM statement.

upvoted 6 times

...