Examine this configuration:
CDB1is a container database.
COMMON_USER_PREFIXisC##.
PDB1is a pluggable database contained inCDB1.
APP1_ROOTis an application container contained inCDB1.
APP1_PDB1is an application PDB contained inAPP1_ROOT.
You execute these commands successfully:

Which two are true? (Choose two.)

1. A. APP1_USER1 can be created in PDB1.
2. B. APP1_USER1 can be created in CDB1.
3. C. APP1_USER1 canhave different privileges in each Application PDB contained in APP1_ROOT.
4. D. C##_APP_USER1 can be created in CDB1.
5. E. P1_USER1 can be created in CDB1.
6. F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

Correct Answer: CF

Which two are trueabout changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

1. A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
2. B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
3. C. After the change, only one undo tablespace can exist in CDB$ROOT.
4. D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
5. E. Undo tablespaces existing in PDBs must be dropped before the change.
6. F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Correct Answer: BC
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.

Examine this configuration:
CDB1is a container database.
PDB1andPDB2are pluggable databases inCDB1. You execute these commands successfully:

Which two are true? (Choose two.)

1. A. PDB1 and PDB2 are in MOUNT state.
2. B. Redo logs are opened.
3. C. PDB1 and PDB2 are in READ ONLY state.
4. D. CDB$ROOT is in MOUNT state.
5. E. PDB$SEED is in READ ONLY state.

Correct Answer: BE

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

1. A. ADDM can recommend shrinking the buffer cache.
2. B. ADDM can recommend extending the buffer cache.
3. C. By default, MMON creates an AWR snapshot every 30 minutes.
4. D. ADDM performs itsanalysis only when a DBA requests it.
5. E. By default, AWR snapshots are automatically purged after eight days.
6. F. AWR snapshots must be deleted when no longer required by ADDM.

Correct Answer: AEF

Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

1. A. It can be performed using anauxiliary instance managed by a DBA.
2. B. It can be used to recover a truncated table.
3. C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
4. D. RMAN always includes tablespaces containing undo segments in the recovery set.
5. E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
6. F. flashback database must be enabled for it to work.
7. G. It can be used to recover a dropped tablespace.
8. H. It can be performed using an auxiliary instance managed by RMAN.

Correct Answer: AEFH