최신 1Z0-083 무료덤프 - Oracle Database Administration II

A. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

B. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

C. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

D. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

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

B. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

C. Data file 24 must be recovered while PDB2 is closed.

D. Data file 24 can be recovered while PDB2 is opened.

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

A. It can have new application PDBs created by copying PDB$SEED.

B. Two or more application PDBs in the same application container can share access to tables.

C. It always has a new application PDBs created by copying PDB$SEED.

D. It always contains multiple applications.

E. It always contains a single application.

F. Two or more application PDBs in the same application container can be given exclusive access to some tables.

A. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

B. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

C. Recovery begins from the beginning of the CURRENT redo log group.

D. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

E. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

F. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

A. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.

B. The source PDB can be in MOUNT or OPEN state.

C. Automatic conversion of endianess occurs.

D. The source PDB must be in MOUNT state.

E. The source and target platforms must have the same endianess.

F. The source PDB must not be an application root.

A. It cannot be used to upgrade Oracle Database homes.

B. It can be used to provision applications.

C. It can be used to patch Grid Infrastructure homes containing Oracle Restart.

D. It can be used to provision middleware.

E. It is an Oracle Database service

A. It can be used to apply interim patches to the Grid Infrastructure and Database Home combination.

B. It supports Rolling Patching.

C. It requires installation of Oracle Universal Installer.

D. It is a Java-based utility for applying patchsets.

E. It must be invoked as the user that owns the software being patched.

F. It is platform independent.

A. when the duplicate ... from active database command contains the section size clause

B. when you perform active database duplication on a database that has readonly tablespaces

C. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

D. when you perform active database duplication on a database with flashback disabled

E. when you specify set encryption before the duplicate ... from active database command

A. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

D. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

E. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

A. All AWR tables belong to the SYSTEM schema.

B. The AWR data is stored in memory and in t he database.

C. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

D. AWR contains system wide tracing and logging information.

E. The snapshots collected by AWR are used by the self-tuning components in the database

A. Media Management messages for SBT devices are always written to sbtio.log.

B. Media Management messages for SBT devices are written to an Oracle trace file.

C. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

D. RMAN error stacks should be read from the top down as that is the order in which errors are generated.

E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

F. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

A. They can be retained forever.

B. They are generated if STATISTICS_LEVEL is set to TYPICAL.

C. They are always created automatically.

D. They are generated if STATISTICS_LEVEL is set to ALL.

E. They are generated if STATISTICS_LEVEL is set to BASIC.

F. They are always created manually.

A. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

B. FLASHBACK LOGS are archived after a log switch.

C. It always generates REDO and UNDO.

D. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

E. It requires that the target database be in ARCHIVELOG mode.

F. A database can be flashed back using SQL*PLUS.