What is a trigger?
Answers were Sorted based on User's Feedback
Answer / guest
A piece of logic written in PL/SQL
Executed at the arrival of a SQL*FORMS event
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / cijo
Triggers are procedures that are stored in the database and
are implicitly run, or fired, when something happens.
Traditionally, triggers supported the execution of a PL/SQL
block when an INSERT, UPDATE, or DELETE occurred on a table
or view.
Triggers support system and other data events on DATABASE
and SCHEMA.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sneha
Trigger is a mechanism to initiate some code to perform
validation.
It is an initiator.
Is This Answer Correct ? | 1 Yes | 0 No |
You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
Operators used in select statements are?
Explain environment of openedge?
What is the difference between multiload and fastload interms of performance?
what are database files, control files and log files. How many of these files should a database have at least? Why?
What does DLL stands for ?
Explain the importance of database partitioning.
What are the drawback of rdbms?
Does google have a database program?
What do you understand by ‘atomicity’ and ‘aggregation’?
What is sorting in dbms?
What do you mean by Checkbox ?