DBMS | SQL | Question 1

The statement that is executed automatically by the system as a side effect of the modification of the database is
(A) backup
(B) assertion
(C) recovery
(D) trigger

Answer: (D)
Explanation: Triggers are the SQL codes that are automatically executed in response to certain events on a particular table.
These are used to maintain the integrity of the data.

A trigger in SQL works similar to a real-world trigger. For example, when the gun trigger is pulled a bullet is Fired.
Quiz of this Question

Article Tags :

DBMS Quiz

Recommended Articles

1. Configure SQL Jobs in SQL Server using T-SQL

2. DBMS | SQL | Question 2

3. Difference between DBMS and SQL

4. Difference between SQL and T-SQL

5. SQL Server | Convert tables in T-SQL into XML

6. Fragmentation in Distributed DBMS

7. Difference between Assertions and Triggers in DBMS

8. Difference Between DDL and DML in DBMS

9. Difference Between ON DELETE CASCADE and ON DELETE SET NULL in DBMS

10. Query Processing in Distributed DBMS

11. Difference Between Dense Index and Sparse Index in DBMS

12. Intro to SQL Server | Architecture

13. QUOTENAME() Function in SQL Server

14. Delete statement in MS SQL Server

15. SQL Indexes

16. How to Create a Table With a Foreign Key in SQL?

17. REVERSE() Function in SQL Server

18. ISNULL() Function in SQL Server

19. Check whether a Table exists in SQL Server database or not

20. SQL | Query Processing

21. SQL Snapshots

23. SQL Trigger | Book Management Database

24. SQL Query to Get Yesterday and Tomorrow

25. Reverse Statement Word by Word in SQL server