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

A. to exclude a temp tablespace when plugging in a PDB

B. to include specific user tablespaces only when relocating a PDB

C. to specify the list of user tablespaces to include when moving a non-CDB to a PDB

D. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.

E. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

F. to specify the list of tablespaces to include when creating a PDB from the CDB seed

A. When a DML statement is executed successfully by same user in a different session.

B. When a DDL statement is executed successfully by same user in a different session.

C. When a DDL statement is executed successfully by the user in the same session.

D. When a DBA issues a successful SHUTDOWN NORMAL statement and the session terminates normally.

E. When a DML statement is executed successfully by the user in the same session.

A. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).

B. Single-byte character sets always use 8-bit encoding schemes.

C. Single-byte character sets always use 7-bit encoding schemes.

D. Multibyte character sets allow more efficient space utilization than single byte character sets.

E. Single-byte character sets provide better performance than multibyte character sets.

F. Unicode enables information from any language to be stored using a single character set.

A. Tables with not null constraints cannot be recovered.

B. Tables or table partitions can be recovered by using an auxiliary instance only.

C. Tables or table partitions from the system and sysaux tablespaces cannot be recovered.

D. Tables or table partitions with a foreign key cannot be recovered.

E. Tables or table partitions can be recovered only when the database is in mount state.

A. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

B. The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.

C. RMAN encryption keys are stored in a database keystore.

D. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

E. RMAN can encrypt the Oracle Database password file.

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

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

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 disk can be duplexed to disk by backing up the backup set that is already on disk.

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

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. It provides before and after execution statistics for each SQL statement in the analysis task

B. It is integrated with the SQL Access Advisor.

C. SQL statements that were originally run concurrently are run concurrently by SPA.

D. It predicts the impact of system changes on SQL workload response time.

E. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

A. configuring the OS for Oracle Automatic Storage Management shared storage access

B. creating thte oraInventory (oinstall) group

C. creating the oracle OS user

D. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

E. creating the OSDBA (dba) group

F. creating the grid OS user

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

B. It succeeds only if the target database is in MOUNT state.

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

D. It fails because there is no connection to a recovery catalog.

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. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

B. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

D. In a PDB plan, subplans may be used with up to eight consumer groups.

E. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

A. V$SESSTAT

B. V$SESSION_WAIT_CLASS

C. V$SESSION_EVENT

D. V$SESSION

E. V$SESSION_WAIT

A. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

B. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

C. Space is always reclaimed proactively before space pressure occurs.

D. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

E. Space might be reclaimed proactively before space pressure occurs.

A. It cannot be backed up manually as a binary copy.

B. It can be backed up manually as a trace file containing SQL statements for control file recreation.

C. It gets backed up automatically by RMAN as a trace file containing SQL statements for control file recreation when a database backup occurs.

D. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

E. It can get backed up automatically as a binary copy.

F. It can be backed up manually as a binary copy.

A. AWR Compare Period report

B. Compare Period ADDM report

C. Taking a new snapshot and comparing it with a preserved snapshot.

D. Active Session History (ASH) report

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. All archive redo log files are automatically copied to the duplicate database.

B. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.

C. he duplicate command.

D. The duplicate database is created by using the backups created during the execution of

E. The duplicate database is created without using RMAN backups and prod1 is allowed to remain open during duplication.

F. The duplicate database has the same directory structure as the source database.