Oracle
1Z0-072 · Question #34
Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter. Examine these steps. 1. Shut down the database instance. 2. Modify the…
The correct answer is C. 1, 2, 7. See the full explanation below for the reasoning.
Question
Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter. Examine these steps. 1. Shut down the database instance. 2. Modify the parameter in the spfile with scope = SPFILE. 3. Modify the parameter in a pfile. 4. Use the spfile to create a pfile. 5. Use the pfile to create a spfile. 6. Modify the parameter in the spfile with scope = BOTH. 7. Start up the database instance. Which are the minimum required steps in the correct order?
Options
- A2, 1, 7
- B1, 7, 2
- C1, 2, 7
- D6, 1, 7
- E1, 4, 3, 5, 7
How the community answered
(23 responses)- A9% (2)
- B9% (2)
- C78% (18)
- D4% (1)
Community Discussion
No community discussion yet for this question.