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

（A）Use The SQL Tuning Advisor for each of the regressed statements.

（B）Create an adaptive execution plan for each of the regressed statements

（C）Use the SQL Access Advisor for each of the regressed statements.

（D）Create SQL plan directives for each of the regressed statements.

（A）Sequence numbers that are allocated require a COMMIT statement to make the allocation permanent.

（B）The data dictionary is always updated each time a sequence number is allocated.

（C）A sequence can provide numeric values for more than one column or table.

（D）A sequence can issue the same number more than once.

（E）Sequences that start with 1 and increment by 1 can never have gaps.

（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）A PDB Lockdown profile can be created in an application root.

（B）A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

（C）A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

（D）A PDB Lockdown profile can be created in a regular PDB.

（E）A PDB Lockdown profile can be created in CDB$ROOT .

（A）Existing Oracle Database instances must be shut down before starting the upgrade.

（B）An existing Oracle base can be used.

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

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

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

（F）Only the grid user can perform the upgrade.

（A）It fails because Data Pump cannot be container.

（B）It creates a full export of the root container and all PDBs.

（C）It creates a full export of only the used while connected to the root container and PDB1.

（D）It creates a full export of the root container and all open PDBs.

（A）RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

（B）The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

（C）The UNDO TABLESPACE clause is never required.

（D）RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

（E）The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

（A）It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

（B）It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

（C）It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

（D）It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

（E）It can be used for applications and middleware.

（A）Test tuned SQL statements one at a time for all statements in the application.

（B）Tune individual SQL statements using the SQL Tuning Advisor.

（C）Identify poorly tuned SQL statements using the SQL Tuning Advisor.

（D）Test the application as a whole using tuned SQL statements.

（E）Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

（F）Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

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

（B）It is platform independent.

（C）It requires installation of Oracle Universal Installer.

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

（E）It supports Rolling Patching.

（F）It must be invoked as the user that owns the software being patched.

（A）A lost password file can be re-created with SQL*PLUS.

（B）A lost PFILE can be re-created alert.log using SQL*PLUS.

（C）A lost password file can be manually re-created with the orapwd utility.

（D）A lost SPFILE can be recovered from memory using SQL*PLUS.

（E）A lost index tablespace can be re-created without performing any recovery.

（F）A lost TEMPFILE must always be re-created manually.

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

（B）when the number of auxiliary channels allocated is equal to or greater than the number of target channels

（C）when you specify set encryption before the duplicate ... from active database command

（D）when you perform active database duplication on a database that has readonly tablespaces

（E）when you perform active database duplication on a database with flashback disabled