Oracle
1Z0-497 · Question #128
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 =…
The correct answer is C. You activate Automatic Shared Memory Management. See the full explanation below for the reasoning.
Question
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;
Options
- AThe database stops (shutdown abort).
- BB) The database Stops (shutdown immediate).
- CYou activate Automatic Shared Memory Management.
- DYou get an error message.
How the community answered
(29 responses)- A10% (3)
- B3% (1)
- C69% (20)
- D17% (5)
Community Discussion
No community discussion yet for this question.