2 - 1 -30

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.). All metrics are instance related. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY. A space usage management alert is automatically cleared after the underlying problem is resolved. They are generated by SMON when a tablespace is 97% full. STATISTICS_LEVEL must be set to ALL to generate alerts.

While backing up to an SBT channel, you determine that the read phase of your compressed RecoveryManager (RMAN) incremental level 0 backup is a bottleneck.FORCE LOGGING is enabled for the database.Which two could improve read performance? (Choose two.). Increase the size of tape I/O buffers. Disable FORCE LOGGING for the database. Increase the size of the database buffer cache. Enable asynchronous disk I/O. Increase the level of RMAN multiplexing.

For which two requirements can you use the USER_TABLESPACE clause with the CREATEPLUGGABLE DATABASE command? (Choose two.). to specify a default tablespace in a PDB cloned from another PDB in the same CDB. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB. to include specific user tablespaces only when relocating a PDB. to specify the list of user tablespaces to include when moving a non-CDB to a PDB. to exclude a temp tablespace when plugging in a PDB. to specify the list of tablespaces to include when creating a PDB from the CDB seed.