1z0-083 Sample Questions & Answers

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

A A PDB snapshot is always a full copy of the source PDB.

A PDB snapshot is always a sparse copy of the source PDB.

A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

A PDB snapshot depends on a storage snapshot which can be storedo n any file system.

A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

A snapshot copy PDB can be created from a stand-alone clone PDB.

Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained

Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.

Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.

The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory grou

The Oracle Grid Infrastructure installation must be owned by the grid user.

The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binarie

The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups

The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

RMAN encryption keys are stored in a database keystore.

RMAN can encrypt the Oracle Database password fil

Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available

The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command

The runfixup.sh script can install missing RPMs.

The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group

|t allows you to select the languages supported by the Oracle database server.

|t can be done before installing Grid Infrastructure for a Standalone Serve

The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

It can be done after installing Grid Infrastructure for a Standalone Server.

The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.