1z0-083 Oracle Exam Questions and Free Practice Test

Question 19

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

A. All metrics are instance related.

B. Cleared statefulalerts are displayed by querying DBA_ALERT_HISTORY.

C. A space usage management alert is automatically cleared after the underlying problem is resolved.

D. They are generated by SMON when a tablespace is 97% full.

E. Metrics are statistical counts for aspecific unit.

F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Correct Answer:BCE

Question 20

Which two are trueabout changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

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

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

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

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

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

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

Correct Answer:BC
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.