dbms_alert is an asynchronronous transaction control mechanism but which procedure is used to unsubscribe to one or more alerts?

Options
- REMOVE
- REMOVEALL
- REGISTER
- SIGNAL

CORRECT ANSWER : REMOVE

Discussion Board
DBMS_ALERT

DBMS_ALERT supports asynchronous notification of database events (alerts). By appropriate use of this package and database triggers, an application can notify itself whenever values of interest in the database are changed. REMOVE procedure enables a session that is no longer interested in an alert to remove that alert from its registration list. Removing an alert reduces the amount of work done by signalers of the alert.

Prajakta Pandit 02-28-2017 12:42 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲