Oracle Exam 1Z0-497 Topic 2 Question 87 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 87
Topic #: 2

[All 1Z0-497 Questions]

What happens when you execute these SQL statements?

ALTER SYSTEM SET SGA_TARGET = 992M;

ALTER SYSTEM SET SHARED_POOL_SIZE = 0;

ALTER SYSTEM SET LARGE_POOL_SIZE = 0;

ALTER SYSTEM SET JAVA_POOL_SIZE = 0;

ALTER SYSTEM SET DB_CACHE_SIZE = 0;

ALTER SYSTEM SET STREAMS POOL SIZE = 0;

AThe database stops (shutdown abort).

BB) The database Stops (shutdown immediate).

CYou activate Automatic Shared Memory Management.

DYou get an error message.

Show Suggested Answer

Suggested Answer: C

http://www.orafaq.com/forum/t/67825/0/ (see the second post)

by Jenelle at Mar 05, 2024, 09:48 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Noel

6 months ago

I think getting an error message is more likely if you set the memory sizes to 0.

upvoted 0 times

...

Rolland

6 months ago

Yes, it would dynamically manage the memory allocation based on workload.

upvoted 0 times

...

Elenore

7 months ago

Do you agree that activating Automatic Shared Memory Management could be a better option?

upvoted 0 times

...

Noel

7 months ago

That makes sense, those statements are altering important memory settings.

upvoted 0 times

...

Rolland

7 months ago

I think the database stops (shutdown immediate).

upvoted 0 times

...

Elenore

7 months ago

What do you think happens when you execute those SQL statements?

upvoted 0 times

...