A. Common roles can be created in the root and PDBs.

B. Local roles can be granted only to local users.

C. A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs

D. Common roles can be granted to both local and common users.

E. When a role is granted to a user, the privileges in the role are limited to the context of the PDB.

A. Oracle Streams

B. Oracle Data Guard

C. Oracle GoldenGate

D. Oracle Real Application Clusters

A. when multiple databases are to be registered with the listener

B. when users need to connect the database instance by using the host naming method

C. when DBAs need to connect remotely to start up the database instance

D. when the database instance to be registered with the listener is configured in shared server mode

A. For image copies, sections are backed up in parallel and recomposed at the end.

B. It supports incremental backups and image copies.

C. Backup for each data file is divided into sections and is backed up in parallel. However, for image copies, sections are backed up sequentially.

D. It is available only for full backups.

A. You can clone only one PDB (either PDB1 or PDB2) into the same CD

B. Cloning a PDB can use the source files copy method to the target PDB files.

C. You cannot do this, because you can only clone PDBs into another CDB.

D. Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.

A. They are not allowed to perform any operations till the listener is started.

B. They can perform only queries.

C. They are terminated and the active transactions are rolled back.

D. They are not affected and continue to function normally.