Free Oracle 1Z0-083 Exam Dumps Questions & Answers

Which three are true about performing an Oracle Database install on Linux? (Choose three.)

• A.  The runfixup.sh script can install missing RPMs.
• B.  It allows you to select the languages supported by the Oracle database server.
• C.  The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
• D.  It can be done before installing Grid Infrastructure for a Standalone Server.
• E.  The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
• F.  The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.
• G.  It can be done after installing Grid Infrastructure for a Standalone Server.

Which two are true about backup encryption?

• A.  Image copies can be encrypted.
• B.  Backup encryption can be enabled selectively for specific tablespaces.
• C.  The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
• D.  The Transparent Data Encryption (TDE) keystore is backed up using RMAN.
• E.  Keystore-based encryption is the default mode for RMAN backup encryption.
• F.  Vendor-specific media management software can be used for making encrypted RMAN backups to media.

Examine the RMAN command:
RMAN> RUN { ALLOCATE CHANNEL
c1 DEVICE TYPE sbt; ALLOCATE CHANNEL
c2 DEVICE TYPE sbt; ALLOCATE CHANNEL
c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?

• A.  It uses parallelization for the backup set.
• B.  It uses multisection backup.
• C.  It creates compressed backup sets.
• D.  It uses asynchronousI/O for the backup.

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

• A.  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.
• B.  Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGETis set lower than the time they have already been retained.
• C.  Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGETbefore there is space pressure.
• D.  Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGETonly after there is space pressure.
• E.  Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGETis changed.

Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area? (Choose two.)

• A.  the backup retention policy
• B.  the archived log deletion policy
• C.  the backup optimization policy
• D.  the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
• E.  using guaranteed UNDO retention
• F.  the DB_RECOVERY_FILE_DEST parameter setting