Oracle Database Administration II Free Sample Questions

Data file 24 can be recovered while PDB2 is opened.

Data file 24 must be recovered while the CDB is opened.

Data file 24 can be recovered while CDBSROOT and PDB$SEED are opened.

Data file 24 cannot be recovered while the CDB is opened.

Data file 24 must be recovered while PDB2 is closed.

It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’

It will create 7u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.

It will re-create 7u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’

|t will create 7u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.

It will fail because there is no autobackup of the controlfiles.

cloning a remote container database in interactive mode

cloning a remote pluggable database in silent mod

relocating a remote pluggable database in interactive mode

relocating a remote container database in silent mode

cloning a remote container database in silent mod

relocating a remote pluggable database in silent mode

relocating a remote container database in interactive mod

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

This cannot be done due to the lack of a clean restore point.

V$SESSION_EVENT

V$SESSTAT

V$SESSION_WAIT

V$SESSION_WAIT_CLASS

V$SESSION

|f an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O

If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottlenec

|f an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.

Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous 1/0/

Data files with a high value in V$BACKUP_ASYNCJO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used

|f the password file location changes, then the new location is used automatically by the Oracle Server.

Schema Only accounts can be granted administrator privileges.

All the Oracle-supplied accounts are Schema Only accounts

Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.

Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

SBT tape compression can be used even if no RMAN compression is configure

Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces

Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

SBT tape compression and RMAN backup compression should be used in parall

The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously

to switch an existing Oracle Database home to a newer release of Oracle software on the same server

to switch to a read-only Oracle home

to switch back to the previous Oracle home as part of a rollback operation

to switch the Oracle Database home when using a centralized Rapid Home Provisioning serv

to switch to a patched Oracle Database home

A The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.

The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is close

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.