A. Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

B. Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

C. Oracle Database Metrics monitor performance using thresholds to generate alerts.

D. Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

E. Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

A. Undo segments can be stored in the SYSTEM tablespace.

B. Undo segments can be stored in the SYSAUX tablespace.

C. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.

D. A single transaction may use multiple undo segments simultaneously.

E. Undo segments can extend when a transaction fills the last extent of the undo segment.

A. All tablespaces may have one or more data files.

B. A segment can span multiple data files in some tablespaces.

C. Segments can span multiple tablespaces.

D. A segment's blocks can be of different sizes.

E. A segment's blocks can be of different sizes.

F. A segment might have only one extent.

A. From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;

B. From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;

C. From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

D. From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

A. Automatic Application Tracing used to collect High-Load SQL statements and statistics.

B. Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.

C. ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.

D. Automatic Diagnostic Collector used to capture and store database errors and hung analysis.

E. Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.

F. Automatic Application Tracing used to collect High-Load SQL statements and statistics.

A. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

B. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.

C. The predefined maintenance window starts automatically with 20% of the system resources ...

D. The SYS_GROUP consumer resource group policies define the resources assigned ...

A. To shrink a table it must have row movement enabled.

B. To shrink a table it must have a UNIQUE KEY constraint.

C. It must be in a tablespace that uses Automatic Segment Space Management (ASSM).

D. It is not possible to shrink either indexes or Index Organized Tables (IOTs).

E. To shrink a table it must have a PRIMARY KEY constraint.

A. It registers database services with all local and remote listeners known to the database instance.

B. It rolls back transactions when a process fails.

C. It records checkpoint information in the control file.

D. It frees resources held by abnormally terminated processes.

E. It frees unused temporary segments.

A. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

C. The file is renamed and stored in the same location.

D. DML may be performed on tables with one or more extents in this data file during the execution of this command.

E. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

A. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.

B. Tables with one or more extents in this data file may be queried during the execution of this command.

C. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

D. DML may be performed on tables with one or more extents in this data file during the execution of this command.

E. It overwrites any existing file with the name sales02.dbf in /u02 by default.