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

（A）By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.

（B）The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.

（C）The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.

（D）The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

（E）The Oracle Grid Infrastructure installation must be owned by the grid user.

（F）The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.

（A）Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

（B）Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

（C）Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

（D）Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

（E）This cannot be done due to the lack of a clean restore point.

（A）PDB1_C2_SRV will be created but not started.

（B）PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.

（C）PDB1_C2_SRV will be created and started automatically.

（D）PDB1 will be created in CDB2 and automatically opened.

（E）PDB1 will be created in CDB2 and left in MOUNT state.

（A）Only the ORCL database instance is started.

（B）Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

（C）Only the ORCL database instance and the +DATA and +FRA disk groups are started.

（D）Only the ORCL database and the ASM instances are started.

（E）The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

（A）TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only.

（B）The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

（C）The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

（D）The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

（E）The C # # A_ADMIN user can perform wallet operations.

（A）creating a database service using DBMS_SERVICE.CREATE_SERVICE

（B）creating a database using the CREATE DATABASE SQL statement

（C）creating an Oracle Database service by modifying the SERVICE_NAMES parameter

（D）creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

（E）creating a disk group using the CREATE DISKGROUP SQL statement

（F）creating a database service using Oracle Database Configuration Assistant (DBCA)

（A）RMAN always uses an auxiliary instance.

（B）RMAN can recover tables owned by the SYS user.

（C）RMAN can recover tables in the SYSTEM tablespace.

（D）RMAN can recover tables in a standby database.

（E）RMAN can recover tables in the SYSAUX tablespace.

（F）RMAN can recover a table after a DDL operation has altered the table structure.

（G）RMAN can recover tables owed by the SYSTEM user.

（A）It contains an image that can be distributed across multiple servers.

（B）It requires the Rapid Home Provisioning service.

（C）It is enabled by performing an Oracle Database installation with database creation and then running the roohctl-enable script.

（D）It is enabled by performing a software-only Oracle Database installation and then running the roohctl-enable script.

（E）Its configuration data and log files reside in subdirectories under the Oracle home.

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

（B）Itsucceeds only if the target database is greater than 400M.

（C）No catalogued backup of the TARGET is used to duplicate the database.

（D）It succeeds.

（E）It fails because connection to the AUXILIARY instance must be as SYSDBA.

（A）By default, the transported database will use Oracle Managed Files (OMF)

（B）A new DBID is automatically created for the transported database.

（C）Databases can be transported between systems with different endian formats.

（D）Data files can be converted on the source system.

（E）Data files can be converted on the destination system.

（F）The password file is automatically converted by RMAN.

（A）Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.

（B）Pre-existing backups of the database to be duplicated are always used if they exist.

（C）Image copies can be used to duplicate the active database.

（D）Backup sets can be used to duplicate the active database.

（E）The active database must be duplicated while in OPEN state.

（F）No connection to the recovery catalog is required for active database duplication.

（G）Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.

（A）after losing a SYSAUX tablespace data file

（B）after losing all members of the CURRENT online redo log group

（C）after losing all members of an INACTIVE online redo log group

（D）after losing all copies of the control file

（E）after losing an UNDO tablespace that is in use

（A）using operating system file copy utilities

（B）using the CREATE TABLE AS SELECT SQL statement

（C）using Oracle Data Pump

（D）using Database Upgrade Assistant

（E）using Database Replay

（F）using SQL Developer

（A）Run OPatch commands from the new Oracle home.

（B）Upgrading user tables that depend on Oracle-maintained abstract data types.

（C）Updating client scripts with the new Oracle home.

（D）Resetting passwords to enforce case-sensitivity.

（E）Migration to unified auditing.

（F）Setting threshold values for tablespace alerts.

（A）Reduced CPU utilization

（B）Reduced logical I/O

（C）Reduced virtual memory utilization

（D）Improved Serial Execution performance

（E）Reduced physical I/O