Free Test Trigger Events – SQL

Q1: Which of the following can activate a trigger in SQL?

A. CREATE B. INSERT C. RENAME D. ALTER

Q2: Which of the following is a valid trigger event in SQL?

A. INSERT B. UPDATE C. DELETE D. All of the above

Q3: When does an AFTER INSERT trigger execute?

A. Before the data is inserted B. After the data is inserted C. During data insertion D. None of the above

Q4: Which clause is used to specify a trigger event?

A. ON B. WHEN C. FOR D. TRIGGER

Q5: Which statement will not fire a DELETE trigger?

A. TRUNCATE B. DELETE C. DROP D. Both A and C

Q6: Which keyword is used to define an action in a trigger?

A. BEGIN B. EXECUTE C. DO D. RUN

Q7: Which event fires a BEFORE UPDATE trigger?

A. After column value changed B. Before column value changed C. Before row deletion D. None

Q8: What is the NEW keyword used for in triggers?

A. To access new row values B. To create a new trigger C. To rollback changes D. To refer to old data

Q9: What is the OLD keyword used for in SQL triggers?

A. Refers to new inserted values B. Refers to deleted row C. Refers to existing row before update D. Used to rollback

Q10: Which database event can be used to fire a trigger?

A. User Login B. Table Rename C. Data Update D. Backup Completion

Q11: Which of the following is not a valid timing for a trigger?

A. BEFORE B. AFTER C. INSTEAD OF D. DURING

Q12: Which event will trigger an AFTER DELETE trigger?

A. Deleting a record B. Inserting a record C. Creating a table D. Altering a record

Q13: Which keyword specifies the table for the trigger?

A. ON B. FOR C. WITH D. TO

Q14: Which trigger event is used to handle actions before new rows are inserted?

A. AFTER INSERT B. BEFORE INSERT C. ON INSERT D. NEW INSERT

Q15: Which trigger event occurs after a table row is modified?

A. AFTER UPDATE B. BEFORE UPDATE C. ON CHANGE D. POST UPDATE

Q16: Which of the following is used inside a trigger to reference column values before an update?

A. NEW B. CURRENT C. OLD D. VALUE

Q17: What type of triggers can access both OLD and NEW row values?

A. BEFORE INSERT B. AFTER DELETE C. BEFORE UPDATE D. AFTER DROP

Q18: Which clause is used to prevent recursive trigger firing?

A. DISABLE B. NO CYCLE C. SET NOCOUNT ON D. NESTLEVEL

Q19: Can a trigger be defined on a view?

A. Yes B. No C. Only on tables D. Only with INSTEAD OF

Q20: What does an INSTEAD OF trigger do?

A. Prevents an operation B. Executes after action C. Replaces default action D. Deletes row

Q21: Which of the following can invoke a trigger?