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

（A）cloning a remote pluggable database in silent mode

（B）relocating a remote pluggable database in interactive mode

（C）cloning a remote container database in interactive mode

（D）cloning a remote container database in silent mode

（E）relocating a remote pluggable database in silent mode

（F）relocating a remote container database in silent mode

（G）relocating a remote container database in interactive mode

（A）when free space in a dictionary managed tablespace falls below a specified percentage

（B）when free space in a locally managed tablespace falls below a specified percentage

（C）when the total number of logons exceeds a specific value

（D）when the number of logons per second exceeds a specific value

（E）when the total number of locked user account exceeds a specific value

（F）when a resumable statement is suspended

（A）The Data Recovery Advisor uses the ADR.

（B）RMAN can always repair corrupt blocks.

（C）The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

（D）The ADR can store metadata in an Oracle Database repository.

（E）The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

（F）Flashback commands help with repairing physical errors.

（A）Add only the CREATE_FILE_DEST clause to the statement.

（B）Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)

（C）Set only the PDB_FILE_NAME_CONVERT parameter.

（D）Add the FILE_NAME_CONVERT clause to the statement and set the
PDB_FILE_NAME_CONVERT parameter.

（E）Enable only OMF.

（F）Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

（A）Unicode enables information from any language to be stored using a single character set.

（B）Single-byte character sets provide better performance than multibyte character sets.

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

（D）Single-byte character sets always use 7-bit encoding schemes.

（E）Multibyte character sets allow more efficient space utilization than single byte character sets.

（F）Single-byte character sets always use 8-bit encoding schemes.

（A）It prevents performance regressions for SQL statements when changes are made.

（B）It can recommend semantic changes to SQL statements.

（C）It only recommends syntactic changes to SQL statements.

（D）It checks each query being analyzed for missing or stale statistics.

（E）It considers all SQL statements being analyzed by the advisor task as a group.

（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）FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

（B）FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

（C）FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

（D）FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.

（E）FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

（F）FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

（A）V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

（B）V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

（C）V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

（D）V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

（E）V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

（F）V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

（A）The control file is backed up automatically each time the SPFILE is backed up manually.

（B）The control file is backed up whenever a new tablespace is created.

（C）The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

（D）It requires the use of fast recovery area (FRA).

（E）The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

（F）The control file is backed up whenever a new table is created.

（A）It is enabled for all users having SELECT privilege on SH.SALES.

（B）Audit records are always stored in an external audit file.

（C）It is only enabled for user SH.

（D）Only successful queries of SH.SALES are written to the audit trail.

（A）Tables with not null constraints cannot be recovered.

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

（C）Tables or table partitions with a foreign key cannot be recovered.

（D）Tables or table partitions from the system and sysaux tablespaces cannot be recovered.

（E）Tables or table partitions can be recovered by using an auxiliary instance only.

（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）the number of data files containing extents belonging to tables updated by a transaction

（B）poorly trained users who do not commit transactions

（C）issuing multiple savepoints during a transaction

（D）poorly written SQL

（E）the number of tablespaces containing tables updated by a transaction

（A）It uses parallelization for the backup set.

（B）It creates compressed backup sets.

（C）It uses asynchronousI/O for the backup.

（D）It uses multisection backup.

（A）They can drop any tablespace.

（B）They cannot create restore points.

（C）They cannot drop tablespaces.

（D）They can create any table.

（E）They can view data from any data dictionary view or dynamic performance view.

（F）They can view data from any user-defined tables.

（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）APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

（B）APP1_USER1 can be created in PDB1.

（C）C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

（D）P1_USER1 can be created in CDB1.

（E）C##_APP_USER1 can be created in CDB1.

（F）APP1_USER1 can be created in CDB1.

（A）Run ADDM in diagnostic mode.

（B）Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

（C）Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

（D）Enable Memory Access Mode, which reads performance data from SGA.

（E）Use emergency monitoring to fetch data directly from SGA for analysis.