1Z1-083 無料問題集「Oracle Database Administration II」

（A）A failure can be closed only when it has been repaired.

（B）Data Recovery Advisor can proactively check for failures.

（C）Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

（D）The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

（E）Data Recovery Advisor can be used if a database is closed.

（A）All historical data older than two years, if any, is purged from the flashback archive FDA1.

（B）An error is returned because the retention period cannot be reduced.

（C）All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years

（D）All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

（A）Reduced CPU utilization

（B）Reduced logical I/O

（C）Reduced virtual memory utilization

（D）Improved Serial Execution performance

（E）Reduced physical I/O

（A）You can use it to create proxy copies for database files.

（B）You can use it to create image copies for database files.

（C）You can use it to create image copies for entire file systems.

（D）You can use it to create backup sets for database files.

（E）You can use it to create proxy copies for entire file systems.

（A）Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

（B）A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

（C）All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

（D）The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.

（E）CDB$ROOT and PDB$SEED are automatically duplicated.

（A）AWR reports can be generated while connected to any container.

（B）AWR snapshots can be created in CDB$ROOT.

（C）No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

（D）AWR snapshots can be created in a PDB.

（E）All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

（F）ADDM can run in a nonroot container.

（A）Some messages in the error stack are not errors.

（B）Media Management errors appear as a line with "Additional information" and a number.

（C）If an RMAN command fails, the output will identify the channel ID where the failure occurred.

（D）Media Management errors appear as a line with "sbtio" and a number.

（E）Media Management errors appear as a line with "sbtio".

（F）If an RMAN command fails, the output will only identify the command that failed.

（A）The recovery catalog is synchronized from the target database control file with a full 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 target database control file is synchronized from the recovery catalog with a full resync at the next backup.

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

（A）It succeeds and creates multisection backup sets that are used for active database duplication.

（B）It fails because there is no connection to a recovery catalog.

（C）It fails because no parallel channels are allocated for the auxiliary database.

（D）It succeeds only if the target database is in MOUNT state.

（A）All the tablespaces in the database must be encrypted

（B）The password for the encryption must be set up.

（C）Oracle Database Vault must be enabled.

（D）Oracle wallet for the encryption must be set up.

（A）A non-unique index can be converted to a unique index using a Data Definition Language (DDL) command.

（B）An index can be scanned to satisfy a query without the indexed table being accessed.

（C）An invisible index is maintained when a Data Manipulation Language (DML) command is per- formed on its underlying table.

（D）An index is always created by scanning the key columns from the underlying table.

（E）A descending index is a type of bitmapped index.

（A）A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

（B）A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

（C）A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

（D）A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

（E）A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

（F）A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

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

（B）If the password file location changes, then the new location is used automatically by the Oracle Server.

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

（D）All the Oracle-supplied accounts are Schema Only accounts.

（E）Schema Only accounts can be granted administrator privileges.

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

（A）Results are written to the alert log.

（B）It analyzes a period of time corresponding to the 12 hours of activity.

（C）It analyzes a period of time corresponding to the last day of activity.

（D）A DBA can run it manually.

（E）It runs automatically after each AWR snapshot.