Oracle Database 19c: Multitenant Architecture Quiz Questions and Answers

Hot remote cloning requires both CDBs to switch from which modes?

Answer :
  • shared UNDO to local UNDO

Explanation :

Hot remote cloning requires both CDBs to switch from shared UNDO mode to local UNDO mode, which means that each PDB uses its own local UNDO tablespace.

Application common objects at the application root level are created in:

Answer :
  • Application root

Explanation :

Application common objects at the application root level are created in the application root.

When can we set a CDB in local UNDO mode (choose Two correct answers) :

Answer :
  • CDB creation
  • Altering CDB

Explanation :

You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property.

A tablespace in a PDB can contain objects associated with:

Answer :
  • Exactly one PDB

Explanation :

A tablespace in a PDB can contain objects associated with exactly one PDB.

In 19c,Instance Creash recovery can be performed at:

Answer :
  • CDB at a whole

Explanation :

Pdb does not have separate instance,CDB is instance is used by PDB's.

In 19C, AWR and ASH data is stored in:

Answer :
  • CDB root

Explanation :

AWR and ASH data is storedthe CDB root when created in the CDB root.

At which DB level, we can set archivelog mode?

Answer :
  • Only at CDB level

Explanation :

Only CDB has redo log files, so archiving can be done at CDB only

To perform hot remote cloning requires both CDBs to be in:

Answer :
  • Local Undo mode

Explanation :

Each PDB uses its own local UNDO tablespace to do Hot Cloning.

Which of following about PDB resource plans is false:?

Answer :
  • PDB resource plan is different to a resource plan for a non-CDB

Explanation :

PDB resource plan is similar to a resource plan for a non-CDB

A CDB can contain up to :

Answer :
  • 4096 PDBS

Explanation :

A CDB can contain up to 4096 PDBs, including the CDB seed