1Z0-083試験無料問題集「Oracle Database Administration II 認定」

A. Use emergency monitoring to fetch data directly from SGA for analysis.

B. Run ADDM in diagnostic mode.

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

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

E. Enable Memory Access Mode, which reads performance data from SGA.

A. by using Active Session History (ASH) data and performing hang analysis

B. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

C. by running ADDM in diagnostic mode

D. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

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

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

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

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

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

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

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

B. It is only enabled for user SH.

C. Audit records are always stored in an external audit file.

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

A. Data file 24 must be recovered while the CDB is opened.

B. Data file 24 cannot be recovered while the CDB is opened.

C. Data file 24 must be recovered while PDB2 is closed.

D. Data file 24 can be recovered while PDB2 is opened.

E. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

A. A row can be migrated to a block in a different extent than the extent containing the original block.

B. An update statement cannot cause chained rows to occur.

C. A row can be migrated to a block in the same extent as the extent containing the original block.

D. An insert statement can result in a migrated row.

E. An insert statement can result in a chained row.

A. PDB$SEED is in READ ONLY state.

B. PDB1 and PDB2 are in MOUNT state.

C. CDB$ROOT is in MOUNT state.

D. PDB1 and PDB2 are in READ ONLY state.

E. Redo logs are opened.

A. It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.

B. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.

C. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks.

D. It requires the operating sys em oracle_base environment variable to be predefined before installation.

E. It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

F. It creates one disk group during installation.

A. Uncommitted transactions in PDB1 have been rolled back.

B. CDB1 is in MOUNT state

C. Uncommitted transactions in CDB1 and PDB1 have been rolled back.

D. PDB1 is closed.

E. CDB1 is shut down.

A. A new DBID is automatically created for the transported database.

B. The password file is automatically converted by RMAN.

C. Data files can be converted on the destination system.

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

E. By default, the transported database will use Oracle Managed Files (OMF)

F. Databases can be transported between systems with different endian formats.

A. RMAN can recover a table after a DDL operation has altered the table structure.

B. RMAN can recover tables in the SYSTEM tablespace.

C. RMAN can recover tables in the SYSAUX tablespace.

D. RMAN can recover tables in a standby database.

E. RMAN always uses an auxiliary instance.

F. RMAN can recover tables owned by the SYS user.

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

A. Active Session History (ASH) report

B. SQL Performance Analyzer

C. Automatic Database Diagnostic Monitor (ADDM) Compare Period report

D. Database Replay

A. Undo tablespaces existing in PDBs must be dropped before the change.

B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

C. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.

E. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

F. After the change, only one undo tablespace can exist in CDB$ROOT.

A. RMAN can recover a table after a DDL operation has altered the table structure.

B. RMAN can recover tables in the SYSTEM tablespace.

C. RMAN can recover tables in the SYSAUX tablespace.

D. RMAN can recover tables in a standby database.

E. RMAN always uses an auxiliary instance.

F. RMAN can recover tables owned by the SYSTEM user.

G. RMAN can recover tables owned by the SYS user.