1z0-083 Exam Dumps - Oracle Database Administration II

V$SESSION_EVENT

V$SESSTAT

V$SESSION_WAIT

V$SESSION_WAIT_CLASS

V$SESSION

The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

All archive logs created after this backup are kept for two years.

The SPFILE is included in the self-contaied archival backup.

The control file is included in the self-contained archival backup.

The restore point is a label for the system change number (SCN) before the archival backup was taken.

It is used in both clustered and non-clustered environments.

You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.

It runs from the Oracle Grid Infrastructure home.

If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.

The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.

It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.

All files in any previous FRA that have not yet been backed up, are backed up.

All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up. C)All files in the current FRA that have been backed up already, are backed up.

All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.

All files in any previous FRA that have been backed up already, are backed up.

All Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up.

All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

It will return an error because creation of a local role is not allowed in CDB$ROOT.

ROLE1 will be created only in CDB$ROOT.

It will return an error because common roles must start with C##.

ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

It will create a multitenant container database (CDB) with only the root opened.

ItwillcreateaCDBwithrootopenedandseedreadonly.

It will create a CDB with root and seed opened and one PDB mounted.

It will create a CDB that must be plugged into an existing CDB.

ItwillcreateaCDBwithrootopenedandseedmounted.

A PDB snapshot depends on an existing storage snapshot of the source PDB.

APDB snapshot can be a full copy of a source PDB.

A PDB snapshot can be a sparse copy of a source PDB

A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

A snapshot copy PDB can be a full copy of a source PDB

The control file is backed up whenever a new tablespace is created.

The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

The control file is backed up whenever a new table is created.

The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

It requires the use of fast recovery area (FRA).

The control file is backed up automatically each time the SPFILE is backed up manually.