MS SQL Server - 58 - Introduction of Trigger MCQ

58 – Introduction of Trigger MCQ

1 / 25

1. What is a DML trigger in SQL Server?

A database maintenance tool

A type of virtual table

A synonym for a view

A stored procedure that fires automatically on specified data changes

2 / 25

2. Which SQL statement is used to create a DML trigger in SQL Server?

DECLARE TRIGGER

CREATE TRIGGER

INSERT TRIGGER

ADD TRIGGER

3 / 25

3. In SQL Server, what is the primary purpose of a DML trigger?

To perform data modifications

To capture and respond to data changes

To create new tables

To enforce referential integrity constraints

4 / 25

4. Which virtual tables are available inside a DML trigger in SQL Server to access old and new data?

current and future

before and after

old and new

deleted and inserted

5 / 25

5. What does the “deleted” virtual table contain in a DML trigger?

Data before the trigger operation

Newly inserted data

Information about the trigger itself

Data after the trigger operation

6 / 25

6. What does the “inserted” virtual table contain in a DML trigger?

Newly inserted data

Information about the trigger itself

Data before the trigger operation

Data after the trigger operation

7 / 25

7. Which SQL Server statement is used to modify the structure of an existing DML trigger?

ALTER TRIGGER

MODIFY TRIGGER

UPDATE TRIGGER

CHANGE TRIGGER

8 / 25

8. What happens when you modify the structure of a DML trigger in SQL Server?

The trigger's logic is updated without affecting its firing conditions.

The trigger is deleted and recreated.

The trigger becomes inactive.

The trigger is renamed.

9 / 25

9. Which clause is used to specify the event that triggers a DML trigger in SQL Server?

AFTER EVENT

TRIGGER EVENT

FOR EACH ROW

ON EVENT

10 / 25

10. In SQL Server, what is the firing order of multiple triggers on the same table for the same event?

Alphabetical order of trigger names

Random order

The order in which the triggers were created

Undefined order

11 / 25

11. Which SQL statement is used to disable a DML trigger in SQL Server temporarily?

ALTER TRIGGER

PAUSE TRIGGER

DISABLE TRIGGER

STOP TRIGGER

12 / 25

12. In SQL Server, which type of trigger is fired before the triggering action?

BEFORE trigger

DURING trigger

AFTER trigger

INSTEAD OF trigger

13 / 25

13. What is the purpose of the “INSTEAD OF” trigger in SQL Server?

To execute instead of the triggering action

To execute before the triggering action

To execute after the triggering action

To execute in parallel with the triggering action

14 / 25

14. Which SQL Server statement is used to enable a previously disabled DML trigger?

START TRIGGER

RESUME TRIGGER

ALTER TRIGGER

ENABLE TRIGGER

15 / 25

15. What is the maximum number of triggers that can be defined for a single table in SQL Server?

Unlimited

16 / 25

16. In SQL Server, what is the difference between an “AFTER” trigger and a “BEFORE” trigger?

Whether they execute before or after the triggering action

Their firing conditions

The order in which they are executed

The type of virtual tables they use

17 / 25

17. Which statement is true about modifying a DML trigger’s structure in SQL Server?

You cannot modify a trigger's structure once it is created.

You can change the database where the trigger resides.

You can change the trigger's firing event.

You can rename a trigger during modification.

18 / 25

18. What is the purpose of using the “NOCOUNT” setting in a DML trigger in SQL Server?

To specify the database where the trigger is executed.

To control whether the trigger affects the row count.

To set the trigger's priority.

To disable the trigger temporarily.

19 / 25

19. What is the syntax for disabling a DML trigger named “MyTrigger” on a table in SQL Server?

STOP TRIGGER MyTrigger ON TableName

DISABLE TRIGGER MyTrigger ON TableName

ALTER TRIGGER MyTrigger ON TableName DISABLE

PAUSE TRIGGER MyTrigger ON TableName

20 / 25

20. In SQL Server, what happens if an “AFTER” trigger is defined as “INSTEAD OF”?

The trigger executes before and after the triggering action.

The trigger executes after the triggering action.

The trigger throws an error.

The trigger becomes inactive.

21 / 25

21. Which statement is true about modifying a DML trigger’s structure in SQL Server?

You cannot modify a trigger's structure once it is created.

You can rename the trigger during modification.

You can change the order of execution of the trigger.

You can change the database where the trigger resides.

22 / 25

22. What is the primary purpose of using “INSTEAD OF” triggers in SQL Server?

To execute instead of the triggering action.

To execute before the triggering action.

To execute in parallel with the triggering action.

To execute after the triggering action.

23 / 25

23. What is the primary purpose of using “AFTER” triggers in SQL Server?

To execute in parallel with the triggering action.

To execute before the triggering action.

To execute after the triggering action.

To execute instead of the triggering action.

24 / 25

24. Which SQL Server statement is used to modify the firing conditions of a DML trigger?

CHANGE TRIGGER

UPDATE TRIGGER

ALTER TRIGGER

MODIFY TRIGGER

25 / 25

25. In SQL Server, what happens when you modify the structure of an “AFTER” trigger to be “INSTEAD OF”?

The trigger becomes inactive.

The trigger throws an error.

The trigger becomes an "AFTER" trigger.

The trigger executes before and after the triggering action.

Your score is

MS SQL Server – 58 – Introduction of Trigger MCQ