Your CDB has two regular PDBs as well as one application container with two applicationPDBs and an application seed
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

1. A. three
2. B. eight
3. C. seven
4. D. six
5. E. five

Correct Answer: C

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

1. A. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
2. B. It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
3. C. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
4. D. A Virtual Private Catalog used to registera container database can be created in a pluggable database.
5. E. It is always possible for RMAN to connect to a pluggable database as a target.
6. F. A Virtual Private Catalog used to register a container database can be created in a non-container database.

Correct Answer: DEF

Which two are true about server-generated alerts? (Choose two.)

1. A. Stateful alerts must be created by a DBA after resolving the problem.
2. B. Stateless alerts can be purged manually from the alert history.
3. C. Stateless alerts can be cleared manually.
4. D. Stateless alerts are automatically cleared.
5. E. Stateful alerts are purged automatically from the alert history.

Correct Answer: BC
Except for the tablespace space usage metric, which is database related, the other metrics are instance related. Threshold alerts are also referred to as stateful alerts which are automatically cleared when an alert condition clears. Stateful alert appears in DBA_OUTSTANDING_ALERTS and when cleared go to DBA_ALERT_HISTORY. Other server-generated alerts correspond to specific database events such as
ORA-* errors, "Snapshot too old" errors, Recovery Area Low on Free Space, Resumable Session Suspended. These are non threshold based alerts, also referred to as stateless alerts. Stateless alerts go directly to the History table. +++ Most alerts (such as "Out of Space") are cleared automatically when the cause of the problem disappears. However, other alerts (such as generic alert log errors) are sent to you for notification and must be acknowledged by you. After taking the corrective measures, you acknowledge an alert by clearing or purging it. Clearing an alert sends the alert to the Alert History which is accessible from Monitoring sub menu. Purging an alert removes it from the Alert History.

Which two are true about gathering optimizer statistics? (Choose two.)

1. A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
2. B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
3. C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
4. D. System statistics can be gathered only while connected to CDB$ROOT.
5. E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Correct Answer: BE
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%.

You are managing this configuration:
CDB1is a container database.
PDB1andPDB2are two pluggable databases inCDB1.
USER1.EMPis a table inPDB1andUSER2.DEPTis a table inPDB2.
CDB1userSYSexecutes these commands after connecting successfully toPDB2:

Which two are true? (Choose two.)

1. A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
2. B. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
3. C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
4. D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
5. E. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
6. F. The insert on USER2.DEPT is uncommitted.
7. G. The inserts on USER1.EMP were committed when the session connected to PDB2.

Correct Answer: FG