OCP CBT Question 539

Please solve the following question.

Examine the following sequence of commands executed by a DBA.Which statement is true regarding the execution of these commands?

Database State`sqlSHOW PARAMETER sga_target;-- sga_target = 8GSHOW PARAMETER sga_max_size;-- sga_max_size = 12G`## Commands Executed`sqlALTER SYSTEM SET sga_target = 10G SCOPE=BOTH;ALTER SYSTEM SET db_cache_size = 6G SCOPE=BOTH;`The database is running with Automatic Shared Memory Management (ASMM) enabled.

Both commands will execute successfully, and db_cache_size will be set to 6G, taking precedence over SGA_TARGET for that component.

The first command will succeed, but the second command will fail because db_cache_size cannot be set directly when SGA_TARGET is active.

Both commands will execute successfully, but sga_target will automatically adjust db_cache_size back to a proportion of the total SGA.

The first command will fail because sga_target cannot exceed 8G.