1z0-083 sample questions

Question 1

Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)

Accepted Answer

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

Accepted Answer

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

Answer

Data file 24 can be recovered while PDB2 is opened.

Answer

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

Answer

Data file 24 must be recovered while PDB2 is closed.

Question 2

Examine this configuration:

While CDB1 is open, 7u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’ is accidentally deleted.

To recover from this critical failure, you execute these commands:

What will be the outcome?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

Question 3

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

Accepted Answer

relocating a remote pluggable database in interactive mode

Accepted Answer

cloning a remote container database in silent mod

Accepted Answer

relocating a remote pluggable database in silent mode

Answer

cloning a remote container database in interactive mode

Answer

cloning a remote pluggable database in silent mod

Answer

relocating a remote container database in silent mode

Answer

relocating a remote container database in interactive mod

Question 4

Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

Question 5

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?

Accepted Answer

V$SESSION_WAIT_CLASS

Answer

V$SESSION_EVENT

Answer

V$SESSTAT

Answer

V$SESSION_WAIT

Answer

V$SESSION

Question 6

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.

Which three are true about diagnosing and tuning these problems? (Choose three.)

Accepted Answer

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

Accepted Answer

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

Accepted Answer

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.

Answer

|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

Answer

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

Answer

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

Answer

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

Question 7

Which three are true in Oracle 19c and later releases? (Choose three.)

Accepted Answer

Schema Only accounts can be granted administrator privileges.

Accepted Answer

All the Oracle-supplied accounts are Schema Only accounts

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 8

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

Accepted Answer

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

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 9

Examine this command: $ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

Accepted Answer

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

Accepted Answer

to switch to a patched Oracle Database home

Answer

to switch to a read-only Oracle home

Answer

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

Answer

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

Question 10

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

Accepted Answer

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

Accepted Answer

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

Accepted Answer

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

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

Oracle Database Administration II Free Sample Questions

Lifetime One

Two

Pro Four

Premium Twelve

1z0-083 Sample Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Trusted by professionals at