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

A. Redo logs are opened.

B. PDB1 and PDB2 are in MOUNT state.

C. CDB$ROOT is in MOUNT state.

D. PDB$SEED is in READ ONLY state.

E. PDB1 and PDB2 are in READ ONLY state.

A. using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

B. using RMAN stored scripts

C. creating encrypted backups

D. creating customized reports about a single database's backups

E. using the KEEP FOREVER clause with the BACKUP command

F. using the REPORT SCHEMA command to list a database's current data files and tablespaces

A. the Process Monitor Process (PMON)

B. the log writer process (LGWR)

C. SYSAUX tablespaces

D. the data dictionary in CDB$ROOT

E. undo tablespaces

F. temporary tablespaces

A. It has the same number of roles as CDB1.

B. Service PDB1 is created for remote logins to PDB1.

C. It has no local users.

D. It is in mount state after creation.

E. It has only local roles.

F. It has the same common users defined as does CDB1.

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. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

B. It is only supported for backups to tape via the media management interface.

C. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

D. Duplex backups can contain only data files and control files.

E. It is not supported for image copies.

A. The data file containing the block being recovered remains online.

B. The target database for which one or more blocks are to be recovered must be in the OPEN state.

C. It cannot repair logical corruption.

D. It can be performed on noncorrupt blocks.

E. A block being recovered is not accessible.

F. To use it, Flashback Database must be enabled.

A. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

B. Recovery catalog is resynchronized with the control files of the registered databases.

C. Imported databases are unregistered from the RC11 catalog.

D. All databases registered in the RC11 catalog are registered in the RC12C catalog.

E. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

A. You can use it to create image copies for database files.

B. You can use it to create proxy copies for entire file systems.

C. You can use it to create proxy copies for database files.

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

E. You can use it to create image copies for entire file systems.

A. PDB-level resource plans can limit uncommitted UNDO per consumer group.

B. A CDB-level resource plan can limit session CPU utilization.

C. A PDB-level resource plan can limit session PGA memory.

D. A CDB-level resource plan is mandatory when using PDB-level resource plans.

E. A CDB-level resource plan can limit PDB UNDO use.

F. A CDB-level resource plan can limit PDB CPU utilization.

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

B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

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

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

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

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. Media Management errors appear as a line with "Additional information" and a number.

B. Media Management errors appear as a line with "sbtio".

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

D. If an RMAN command fails, the output will only identify the command that failed.

E. Media Management errors appear as a line with "sbtio" and a number.

F. Some messages in the error stack are not errors.

A. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.

B. They can be created only by using the COPIES option of a BACKUP command.

C. They can be written to media.

D. They must be written to media.

E. They can be written only to disk.

A. Only the grid user can perform the upgrade.

B. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

C. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

D. Existing Oracle Database instances must be shut down before starting the upgrade.

E. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

F. An existing Oracle base can be used.

A. oracle will be granted the SYSASM privilege when installing the Oracle Database software.

B. oracle will be an owner of the Oracle Inventory.

C. oracle must be the owner of every Oracle Database installation.

D. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

E. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

A. A backup set must be written to disk.

B. A data file can be split into multiple sections stored in different backup pieces in the same backup set.

C. A backup set must be written to media.

D. A data file can be split into multiple sections stored in different backup sets.

E. Blocks from multiple data files can be contained in one backup set,

F. A backup set can contain only one backup piece.

G. A backup piece can belong to only one backup set.

H. Blocks from multiple data files can be contained in one backup piece,

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

B. The runfixup.sh script can install missing RPMs.

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

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

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

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

G. It allows you to select the languages supported by the Oracle database server.

A. The CSS daemon runs from the Grid Infrastructure home.

B. It supports volume management, file system, and automatic restart capabilities.

C. It can manage database resources on the server where it is installed or on a different server.

D. It must be installed before the Oracle database software is installed.

E. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.