Oracle Exam 1Z0-062 Topic 7 Question 8 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 8
Topic #: 7

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.)

AEdit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.

BCreate an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.

CCreate an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.

DCreate an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

EStart the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.

FUse the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

Show Suggested Answer

Suggested Answer: C, F

by Allene at May 07, 2022, 01:08 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-062 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!