Oracle Exam 1Z0-497 Topic 4 Question 81 Discussion

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

Question #: 81
Topic #: 4

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 An at Oct 20, 2023, 02:18 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!