1z0-083 Practice Test

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

A.

Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

B.

All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

C.

The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.

D.

A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

E.

CDB$ROOT and PDB$SEED are automatically duplicated.

A user complains about poor database performance.
You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all
waits waited on by a session at least once?

A.

V$SESSION_EVENT

B.

V$SESSTAT

C.

V$SESSION_WAIT

D.

V$SESSION_WAIT_CLASS

E.

V$SESSION

How do you configure a CDB for local undo mode?

A.

Open the CDB instance in upgrade mode. In cdb$root, execute alter database local undo on, and then
restart the CDB instance

B.

Open the CDB in read-only mode. In cdb$root, execute alter database local undo on, and then change
the CDB to read/write mode

C.

Open the CDB instance in restricted mode. In cdb$root, execute alter database local undo on. create an
undo tablespace in each PDB, and then restart the CDB instance

D.

Open 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.

E.

Open 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.

Examine these actions:
1.Create a new database for a recovery catalog.
2.Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3.Configure ARCHIVELOG mode for the catalog database.
4.Create a user to own the recovery catalog schema with quota on the tablespace that will containthe
catalog.
5.Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6.Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATECATALOG command?

A.

2, 4, 5, 6

B.

1, 2, 3, 4, 5, 6

C.

1, 2, 4, 5

D.

2, 4, 5

E.

1, 3, 4, 5

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB,
HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain
HR_ROOT.
Which two are always true? (Choose two.)

A.

CDB1 and CDB2 must be in shared undo mode.

B.

A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C.

All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D.

Cloning HR_ROOT automatically clones HR_PDB1.

E.

The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.