Interview Questions.

Question 1. What Are Oracle Alerts?

Answer :

Oracle Alerts are used to screen uncommon or essential interest inside a chosen database. The flexibility of ALERTS lets in a database administrator the potential to display activities from table area sizing to sports related to specific packages. Alerts can be created to reveal a procedure within the database and to notify a particular man or woman of the repute of the technique.

Question 2. What Are The Different Types Of Alerts, Define It?

Answer :

You can outline considered one of two forms of alerts:

occasion alert or a periodic alert.

Event alert: An occasion alert right away notifies you of activity for your database as it happens.
Periodic alert: A periodic alert, on the other hand, tests the database for information according to a Schedule  you define.
PL/SQL Interview Questions
Question three. What Are The Different Business Uses Of Alerts?

Answer :

Keep you informed of important hobby on your database
Deliver key facts from your applications, inside the format  you pick to offer you with normal reviews on your database statistics
Automate device protection and recurring online obligations Information approximately exception conditions.
Question four. What Can Be Done With Alerts?

Answer :

You can send notifications
You can ship log files as attachments to notifications
You can call PL/SQL saved techniques.
You can send approval emails and get the results.
Print a few content dynamically
Question five. What Types Of Actions Can Be Generated When An Alert Is Triggered?

Answer :

When an alert is performed, the alert can send an e-mail message, run a concurrent program, run an operating system script, or run a SQL announcement script. Using response processing, Oracle Alerts can solicit a reaction from a selected person and perform an movement primarily based on the reaction that it receives.

SQL Interview Questions
Question 6. What Is On-call for Periodic Alert?

Answer :

It is a periodic alert with frequency as ‘On-Demand’. That approach there may be no unique length assigned to this alert and you could run this alert at any time you need the use of Request Periodic Alert Check shape.

Question 7. What Database Events Can Cause What Actions?

Answer :

An insert and/or an update to a particular database desk

Oracle Security Interview Questions
Question 8. What Actions Can You Perform In An Alert?

Answer :

An action can entail sending someone an e-mail message, jogging a concurrent application, walking an working script, or strolling a SQL announcement script. You consist of all of the movements you want Oracle Alert to perform, in an action set.

Question 9. How Event Alert Works?

Answer :

When you define an event alert to monitor a table for inserts and/or updates, any insert or update to the desk will cause the event alert. When an insert or replace to an event desk occurs, Oracle Alert submits to the concurrent supervisor, a request to run a concurrent program referred to as Check Event Alert. The concurrent supervisor runs this request in step with its priority within the concurrent queue. When the request is run, Check Event Alert executes the alert Select declaration. If the Select statement unearths exceptions, Check Event Alert performs the moves defined within the enabled action set for the alert. If the Select assertion does now not locate any exceptions, Check Event Alert performs the No Exception moves in the enabled action set for the alert.

Oracle Forms And Reports Interview Questions
Question 10. What Do You Specify When Creating A Periodic Alert?

Answer :

A SQL Select announcement that retrieves particular database statistics
The frequency that you need the periodic alert to run the SQL statement
Actions which you want Oracle Alert to perform once it runs the SQL assertion.
Question 11. Can You Define Alert On Oracle Applications Tables?

Answer :

Yes

Oracle Apps DBA Interview Questions
Question 12. What Is Periodic Set?

Answer :

You can create a set of periodic signals that Oracle Alert assessments simultaneously. Use the Request Periodic Alert Check window to test the periodic set. Note that each periodic provide you with a warning encompass in a periodic set keeps to run in keeping with its personally described frequency.

PL/SQL Interview Questions
Question thirteen. How Alert Is Different From Database Triggers?

Answer :

Code may be modified and regarded in a screen
Periodic alert isn't viable via Database cause
Oracle Alert will also transfer your complete alert definition throughout databases. You can immediately leverage the paintings carried out in a single vicinity to all your structures.
Customizable Alert Frequency with Oracle Alert, you can pick the frequencyof each periodic alert. You may additionally need to check a few alerts every day, a few handiest once a month, nonetheless others simplest whilst you explicitly request them.
Question 14. What Is Action Set?

Answer :

An motion set can consist of an infinite wide variety of actions and any combination of movements and movement businesses to your alert. You can outline as many action units as you need for every alert. Oracle Alert executes the alert Select statement once for every movement set you outline. During every action set check, Oracle Alert executes every movement set member in the series you specify.

Question 15. Can You Define Detailed Or Summary Actions In Alert?

Answer :

Yes, Detail or Summary Actions you can pick out to have Oracle Alert perform actions based totally on a single exception or a aggregate of exceptions discovered in your database.

Oracle Workflow Interview Questions
Question 16. What Is Distribution List In Oracle Alert?

Answer :

Distribution lists permit you to predefine a hard and fast of message recipients to be used on many actions. If a recipient modifications, you want only regulate it in the distribution list, now not inside the person message movements.

Question 17. Can You Specify History Maintenance?

Answer :

Alert History Oracle Alert can keep a document of the moves it takes and the exceptions it reveals to your database, for as many days as you specify.

Oracle D2K Interview Questions
Question 18. Can You Perform Actions When No Exceptions Are Found?

Answer :

No Exception Actions : Oracle Alert can perform moves if it unearths no exceptions in your database, equal as alert movements.

SQL Interview Questions
Question 19. What Are The Action Levels For Your Alert Actions?

Answer :

There are three varieties of degree on your movement:

Detail, Summary and No Exception.

During an alert test, an in depth movement plays as soon as for each individual exception determined, a summary action performs as soon as for all exceptions determined, and a no exception action plays whilst no exceptions are found.