Oracle 1Z0-083 Quiz 13 Topic 2 Questions 61-65

Question: 1

Your container database, CDB1, is in local undo mode.

You successfully execute this command while connected to CDB1:

CREATE PLUGGABLE DATABASE pdb1

ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)

CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';

Which three are true about PDB1? (Choose three.)

AService PDB1 is created for remote logins to PDB1.

BIt is in mount state after creation.

CIt has no local users.

DIt has the same number of roles as CDB1.

EIt has the same common users defined as does CDB1.

FIt has only local roles.

Show Answer

Question: 2

How do you configure a CDB for local undo mode?

AOpen the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON,
and then restart the CDB instance.

BOpen the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON,
and create an UNDO tablespace in each PDB, then restart the CDB instance.

COpen the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER
DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

DOpen the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON,
and then change the CDB to read/write mode.

EOpen the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON,
create an UNDO tablespace, and then restart the CDB instance.

Show Answer

Question: 3

Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target

connection in Oracle Database 19c and later releases? (Choose three.)

AThe base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

BThe base catalog must be enabled for Virtual Private Catalog use.

CThe target PDB must be registered in a base catalog.

DThe base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered
in the Virtual Private Catalog.

EThe target PDB must be registered in a Virtual Private Catalog.

FThe target PDB must be registered in both the base catalog and the Virtual Private Catalog.

Show Answer

Question: 4

Which three activities are possible for PDBs? (Choose three.)

Aconverting an application PDB to a regular PDB

Bconverting an application PDB to an application root

Cconverting an application seed to an application PDB

Dconverting an application PDB to an application seed

Econverting a regular PDB to an application PDB

Fconverting an application container into another application container in a different CDB

Gconverting an application container into another application container in the same CDB

Show Answer

Question: 5

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?

(Choose three.)

AThey can view data from any data dictionary view or dynamic performance view.

BThey cannot create restore points.

CThey cannot drop tablespaces.

DThey can create any table.

EThey can drop any tablespace.

FThey can view data from any user-defined tables.

Show Answer

Oracle 1Z0-083 Quiz:13 Topic:2 Questions:61-65