Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?

A.
because pga_aggregate_target is not set

B.
because statistics_level is set to basic

C.
because memory_target and memory_max_target cannot be equal

D.
because sga_target and memory_target are both set



Leave a Reply 3

Your email address will not be published. Required fields are marked *


realDBA

realDBA

Without seeing the Exhibit .
Just B makes sense.

DBABOG

DBABOG

B, But this question is from the 1Z-062 exam