Oracle
1Z0-497 · Question #128
1Z0-497 Question #128: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-497 to reveal the answer and full explanation for question #128. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-497 to see the answer
You've previewed enough free 1Z0-497 questions. Unlock 1Z0-497 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.