1Z0-082 practice question 21 of 25
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?
Full set: 142 questionsWhen an Oracle instance is started using a Server Parameter File (SPFILE), the ALTER SYSTEM SET command, by default, uses SCOPE=BOTH. This means the change is applied immediately to the running instance (memory) and is also persisted in the SPFILE. This ensures the change will be active after the next instance restart. The existence of a PFILE is irrelevant as the instance is not using it.
A. This option redundantly lists SPFILE twice and is incorrectly formatted.
C. This would be correct only if SCOPE=SPFILE were specified, which is not the default behavior.
D. There is no such component as an "SPFILEc" in the Oracle Database architecture.
E. This would be correct only if SCOPE=MEMORY were specified, which is not the default behavior.
Oracle Database Administrator's Guide
19c
Chapter 2
"Managing Initialization Parameters Using a Server Parameter File". The section "Changing Initialization Parameter Values" states
"If you specify SCOPE=BOTH
then Oracle Database changes the value in memory and in the server parameter file. This is the default."
Oracle Database SQL Language Reference
19c
"ALTER SYSTEM". Under the setclause
the documentation for SCOPE specifies: "BOTH: ... This is the default if the database is started up with a server parameter file."
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
