What is a trigger statement
When a trigger event occurs, any SQL statement that is an instance of the trigger event is referred to as a triggering statement. Triggers defined on tables and triggers defined on views differ in whether the triggering statement is executed: For tables, the trigger event and the trigger action both execute.
Why are Triggers created Mcq
Triggers run after an insert, update, or delete on a table; they are not supported for views.
Which of the following clauses must you include on the Create trigger statement to create a row level trigger
The FOR EACH ROW clause of the CREATE TRIGGER statement is used to create a new row-level trigger.
How many create trigger statement Are there Mcq
The SQL statement that sets off a trigger, such as an INSERT, DELETE, or UPDATE, is the first of three components that make up a trigger.
What are the uses of triggers Mcq
All of the aforementioned purposes—enforcing referential integrity, synchronous table replication, and preventing invalid transactions—are accomplished by triggers.
What statement about triggers is true
Which of the following statements about triggers is true? You use an application trigger to fire when a DELETE statement occurs. You use a database trigger to fire when an INSERT statement occurs.
Which of the following statements can be used to create a table
CREATE TABLE table_name (column_name, column_type) is the appropriate response.
On which of the following you can define database triggers
No matter which user or application issues the statement, database triggers are defined on a table, stored in the related database, and executed as a result of an INSERT, UPDATE, or DELETE statement being issued against a table.
How many types of triggers are present in SQL Server
Up to four different trigger types may be activated by a single SQL statement: BEFORE row triggers, BEFORE statement triggers, and AFTER row triggers.
Which of the following keywords can you use in a trigger to work with the values in a row
When a BEFORE trigger is used in conjunction with an UPDATE statement, you can refer to a value in a row before it is updated by using the BLANK keyword and a column name.
What are the components of a compound trigger
Compound triggers can have up to four sections:
- the section before.
- the section PRIOR TO EACH ROW.
- the section AFTER EACH ROW.
- the following section.
Can one trigger initiate another trigger
You can control whether AFTER triggers can be nested through the nested triggers server configuration option. DML and DDL triggers are both nested when a trigger performs an action that initiates another trigger, which in turn can initiate other triggers, and so on. DML and DDL triggers can be nested up to 32 levels.
Which of the following best describes conditional predicates in a trigger
The special variables that must be DECLAREd within the trigger allow the trigger code to see what data values are being inserted into a row. Which of the following best describes conditional predicates in a trigger?
Can a trigger call a batch class
An Apex trigger can be used to activate Batch Apex, but it must not add more batch jobs than allowed.
Which of the following is not Oracle supported trigger
Which of the following is not an Oracle-supported trigger? The correct response is option (b): DURING. All the other are supported by Oracle except for the During trigger because it is not possible in any database.
What table Cannot have a trigger associated with it
However, there are some restrictions that you should be aware of before utilizing them in your applications. MySQL triggers cannot be used with the SHOW, LOAD DATA, LOAD TABLE, BACKUP DATABASE, RESTORE, FLUSH, and RETURN statements.
Is a table that is being modified by a DML action when a trigger is fired
When a trigger fires, a DML action that modifies a table is said to be constraining.
Which of the following statement will correctly call the exception in a PL SQL block
Which of the following statements will correctly invoke the exception in a PL/SQL block? A – There is no ELSE clause and none of the options in the WHEN clauses of a CASE statement.