Identify the three predefined server-generated alerts. (Choose three.)
A.
Drop User
B.
Privilege Grants
C.
Tablespace Space Usage
D.
Tablespace Reoganization
E.
Resumable Session Suspended
F.
Recovery Area Low On Free Space
G.
SYSTEM Tablespace Size Increment
Explanation:
A server-generated alert is a notification from the Oracle Database server of an impending problem. The notification may contain suggestions for correcting the problem. Notifications are also provided when the problem condition has been cleared. Alerts are automatically generated when a problem occurs or when data does not match expected values for metrics, such as the following:
* Physical Reads Per Second
* User Commits Per Second
* SQL Service Response Time
* Tablespace space usage (C) . For example, by default a server-generated alert is generated for tablespace space usage when the percentage of space usage exceeds either the 85% warning or 97% critical threshold level. Examples of alerts not based on threshold levels are:
* Snapshot Too Old
* Resumable Session Suspended (E)
* Recovery Area Space Usage (F)
REF.: Oracle(r) 10g Administrator Guide, 4-18 and 4-19