creating a multitenant container database plan (CDB plan) using Oracle Database
Resource Manager?
A. MaximumUndo per consumer group
B. Maximum Idle time
C. Parallel server limit
D. CPU
E. Exadata I/O
F. Local file system I/O
Answer: C,E
Your database instance is started with a PFILE.
You want to increase the size of the buffer cache. Free memory is available to increase the
size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?
A. Change is applied to the current instance, but does not persist after instance restart.
B. The value is changed only in the PFILE and takes effect at the next instance startup.
C. The value is changed for the current instance and in the PFILE.
D. It fails because the SCOPE clause is missing.
Answer: A
