1Z0-083 Online Practice Questions and Answers

A database is configured in ARCHIVELOG mode.

Full RMAN backups are taken and no backup to trace has been taken of the control file.

A media failure has occurred.

In which two scenarios is complete recovery possible? (Choose two.)

A. when any archived log from, before, or after the most recent backup is corrupt.

B. after losing all copies of the control file

C. after losing an archived log from after the most recent backup

D. after losing an archived log from before the most recent backup

E. after losing the SYSTEM tablespace

Examine this configuration:

1.

CDB1 is a container database.

2.

PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully:

Which two are true? (Choose two.)

A. PDB1 and PDB2 are in MOUNT state.

B. Redo logs are opened.

C. PDB1 and PDB2 are in READ ONLY state.

D. CDB$ROOT is in MOUNT state.

E. PDB$SEED is in READ ONLY state.

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

A. By default, AWR snapshots are taken every 60 minutes.

B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

C. By default, AWR snapshots are retained for 7 days.

D. The taking of AWR snapshots can be disabled.

E. AWR data is stored in the SYSTEM tablespace.

You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;

What is a prerequisite for the successful execution of this command?

A. RMAN must be connected to the target database instance and the auxiliary instance.

B. A most recent backup set of the PROD database must exist.

C. Flashback must be enabled for the PROD database.

D. The target database must be in MOUNT state.

You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites? (Choose two).

A. an operating system user to own this installation

B. the Oracle Inventory group oinstall

C. an operating system account called grid

D. a group called dba

E. the installation of Oracle ASMLIB

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

A. It is used to change failure priority only for HIGH or LOW priorities.

B. It is used to execute the advised repair script.

C. It is used to change failure priority only for the CRITICAL priority.

D. It is used to explicitly close the open failures.

E. It is used to inform the database about the repair after the repair script executes.

Which three are true about Recovery Manager (RMAN) active database duplication? (Choose three)

A. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.

B. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.

C. Pre-existing backups of the database to be duplicated are always used if they exist.

D. Image copies can be used to duplicate the active database.

E. The active database must be duplicated while in OPEN state.

F. No connection to the recovery catalog is required for active database duplication.

G. Backup sets can be used to duplicate the active database.

Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup? (Choose two).

A. Backups can be taken only if a fast recovery area is configured.

B. Backups can be written only to disk.

C. Backups can be taken only for data files.

D. Binary compression cannot be applied to the backup.

E. Backups can be written only if checksums are stored for each block.

F. Backups can be written only to media.

Which three statements are true about Flashback Database?

A. Flashback logs are written sequentially, and are archived.

B. Flashback Database uses a restored control file to recover a database.

C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

D. Flashback Database can recover a database to the state that it was in before a reset logs operation.

E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Which two are true about memory advisors? (Choose two.)

A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

B. If Automatic Memory Management is enabled, no memory advisors are available.

C. All memory advisors use data from Automatic Workload Repository.

D. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

E. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.