A.True. CREATE SPFILE FROM PFILE works when idle.
B.False. Includes dynamic parameters too.
C.True. CREATE PFILE FROM SPFILE generates a PFILE.
D.False. A PFILE can start the instance if no SPFILE exists.
E.True. Dynamic parameters (e.g., DB_CACHE_SIZE) are modifiable.
[References:Oracle Database Administrator’s Guide 23ai, "Managing Initialization Parameters.", , ]
Submit