A, Not D: In a CDB, PUBLIC is a common role. In a PDB, privileges granted locally to PUBLIC enable all local and
common users to exercise these privileges in this PDB only.
C: A user can only perform common operations on a common role, for example, granting privileges commonly to the
role, when the following criteria are met:
The user is a common user whose current container is root.
The user has the SET CONTAINER privilege granted commonly, which means that the privilege applies in all
containers.
The user has privilege controlling the ability to perform the specified operation, and this privilege has been granted
commonly
Incorrect:
Note:
* Every privilege and role granted to Oracle-supplied users and roles is granted commonly except for system privileges
granted to PUBLIC, which are granted locally.

* Data Recovery Advisor can diagnose failures such as the following:
/ (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the
correct access permissions, have been taken offline, and so on
/ (A, E) Physical corruptions such as block checksum failures and invalid block header field values
/ Inconsistencies such as a datafile that is older than other database files
/ I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource
limits (for example, the number of open files)
* The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the
appropriate repair options, and executes repairs at the user's request. This reduces the complexity of recovery
process, thereby reducing the Mean Time To Recover (MTTR).