Which three statements are true concerning the multitenant architecture?
A.
Each pluggable database (PDB) has its own set of background processes.
B.
A PDB can have a private temp tablespace.
C.
PDBs can share the sysaux tablespace.
D.
Log switches occur only at the multitenant container database (CDB) level.
E.
Different PDBs can have different default block sizes.
F.
PDBs share a common system tablespace.
G.
Instance recovery is always performed at the CDB level.
Explanation:
B:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user
created tablespaces in it.
* There is one default temporary tablespace for the entire CDB. However, you can create
additional temporary tablespaces in individual PDBs.
D:
* There is a single redo log and a single control file for an entire CDB
* A log switch is the point at which the database stops writing to one redo log file and begins
writing to another. Normally, a log switch occurs when the current redo log file is completely filled
and writing must continue to the next redo log file.
G: instance recovery
The automatic application of redo log records to uncommitted data blocks when an database
instance is restarted after a failure.Incorrect:
Not A:
* There is one set of background processes shared by the root and all PDBs. –
* High consolidation density. The many pluggable databases in a single
container database share its memory and background processes, letting you operate
many more pluggable databases on a particular platform than you can single databases
that use the old architecture.
Not C: There is a separate SYSAUX tablespace for the root and for each PDB.
Not F: There is a separate SYSTEM tablespace for the root and for each PDB. –
B,D,G
for the fourth option I will choose E
B D and G
BDG
BDG
B,D,G
D correct
SQL> show con_name
CON_NAME
——————————
CDB$ROOT
SQL>
SQL> alter system switch logfile;
System altered.
SQL>
SQL> alter session set container=pdb2;
Session altered.
SQL> show con_name
CON_NAME
——————————
PDB2
SQL>
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
A C e F incorrect
E incorrect.
SQL> show con_name
CON_NAME
——————————
PDB2
SQL>
SQL> alter system set db_block_size=4096 scope=spfile;
alter system set db_block_size=4096 scope=spfile
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
BDG, but I think also E is correct
You need to set one of the parameters, depending on what block size your pdb is:
db_16k_cache_size
db_2k_cache_size
db_32k_cache_size
db_4k_cache_size
db_8k_cache_size
I think is B,D,F
sorry.
correct is B,D,G