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