READ Free Dumps For Oracle- 1z0-062
Question ID 2350 | Which statement is true regarding the startup of a database instance? |
Option A | A. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option. |
Option B | B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option. |
Option C |
|
Option D | D. Media recovery is required when the database is shut down by using either the immediate option or the abort option. |
Option E | E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE. |
Correct Answer | B |
Question ID 2351 | Examine the memory-related parameters set in the SPFILE of an Oracle database: |
Option A | A. Only SGA components are sized automatically- |
Option B | B. Memory is dynamically re-allocated between the SGA and PGA as needed. |
Option C | C. The size of the PGA cannot grow automatically beyond 500 MB. |
Option D | D. The value of the MEMORY_TARGET parameter cannot be changed dynamically. |
Correct Answer | C |