READ Free Dumps For Oracle- 1z0-060
| Question ID 20783 | Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?
|
| Option A | It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
|
| Option B | It succeeds only if memory is available from the autotuned components if SGA.
|
| Option C | It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
|
| Option D | It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
|
| Correct Answer | B |
Explanation
| Question ID 20784 | Which three statements are true concerning unplugging a pluggable database (PDB)?
|
| Option A | The PDB must be open in read only mode.
|
| Option B | The PDB must be closed.
|
| Option C | The unplugged PDB becomes a non-CDB.
|
| Option D | The unplugged PDB can be plugged into the same multitenant container database (CDB)
|
| Option E | The unplugged PDB can be plugged into another CDB.
|
| Option F | The PDB data files are automatically removed from disk.
|
| Correct Answer | B,D,E |
Explanation D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference. E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB's datafiles can remain in place. The PDB must be closed before it can be unplugged. When you unplug a PDB from a CDB, the unplugged PDB is in mounted mode. The unplug operation makes some changes in the PDB's data files to record, for example, that the PDB was successfully unplugged. Because it is still part of the CDB, the unplugged PDB is included in an RMAN backup of the entire CDB. Such a backup provides a convenient way to archive the unplugged PDB in case it is needed in the future. Reference: Oracle White Paper, Oracle Multitenant