Which statement is correct about the database?

Correct Answer for the Question – Which statement is correct about the database? is given below

memory_target big integer 808Mpga_aggregate_target big integer 0sga_target big integer 0SQL> SHOW PARAMETER SGA_MAX_SIZENAME TYPE VALUE-————————————————————————————————sga_max_size big integer 808MWhich statement is correct about the database?

Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and C. SGA_TARGET are set.

Correct Answer

The Correct Answer for this Question is

Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.

Explanation

The Question – Which statement is correct about the database? has been answered correctly and answer for the question is Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously the same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for quick access in the future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact us via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment