exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 117 discussion

Actual exam question from Oracle's 1z0-082
Question #: 117
Topic #: 1
[All 1z0-082 Questions]

Your database instance is started with an SPFILE.

A PFILE is also available.

You execute this command:

ALTER SYSTEM SET DB_CACHE_SIZE=100K;

Where is the value changed?

  • A. in the SPFILE, PFILE, and memory
  • B. in the SPFILE and in memory
  • C. only in the SPFILE
  • D. only in memory
  • E. in the SPFILE and PFILE
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
auwia
1 year ago
Selected Answer: B
Correct answer is B.
upvoted 3 times
...
Darkseid1231
1 year ago
I will go for D as the correct answer. Scope=spfile is not specify.
upvoted 1 times
auwia
1 year ago
The scope is intrinsic because you started the instance by the spfile, so the scope is already set.
upvoted 1 times
...
...
RaNik69
1 year, 2 months ago
Selected Answer: B
When you issue the ALTER SYSTEM statement while connected to a non-CDB or a CDB root, the scope depends on whether you started up the database using a traditional plain-text parameter file (pfile) or server parameter file (spfile). MEMORY indicates that the change is made in memory, takes effect immediately, and persists until the database is shut down. If you started up the database using a parameter file (pfile), then this is the only scope you can specify. SPFILE indicates that the change is made in the server parameter file. The new setting takes effect when the database is next shut down and started up again. You must specify SPFILE when changing the value of a static parameter that is described as not modifiable in Oracle Database Reference. BOTH indicates that the change is made in memory and in the server parameter file. The new setting takes effect immediately and persists after the database is shut down and started up again. If a server parameter file was used to start up the database, then BOTH is the default. If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...