New Features for Administrators - Question 053

The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?

A. Only MEMORY is updated

B. Only SPFILE values are updated

C. Only init.ora parameters are updated.

D. Both SPFILE and MEMORY memory values are updated.

E. Both init.ora parameters and SPFILE values are updated.

Answer: A

Explanation:

The default scope of changes made by using the SET clause of the ALTER SYSTEM statement is only MEMORY scope. The MEMORY scope only makes changes in memory for the current instance and not the SPFILE; it does not persist.

Incorrect Answers

B: The SPFILE is not a default scope of changes made by using the SET clause of the ALTER SYSTEM statement. It makes changes only in the SPFILE and not in the instance.

C: The ALTER SYSTEM command does not change the init.ora file.

D: Only MEMORY scope is updated by default.

E: The init.ora file is not updated by the ALTER SYSTEM command.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 80-83

Chapter 2: Availability Enhancements

Oracle 9i New Features, Robert Freeman, p. 32-37

Chapter 1: Oracle9i Database Administration and Management Features