ISRO CS 2009
October 17, 2023Software-Engineering
October 17, 2023NTA-UGC-NET 2021 Dec & 2022 June Paper-2
| Question 1 |
A trigger is
| A statement that enables to start DBMS | |
| A statement that is executed by the user when debugging an application program. | |
| A condition the system tests for the validity of the database user. | |
| A statement that is executed automatically by the system as a side effect of modification to the database. |
Question 1 Explanation:
A triggering event or statement is the SQL statement that causes a trigger to be fired.
A triggering event can be an INSERT, UPDATE, or DELETE statement on a table.
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.
The trigger is mostly used for maintaining the integrity of the information on the database. For example, when a new record (representing a new worker) is added to the employees table, new records should also be created in the tables of the taxes, vacations and salaries.
Triggers can also be used to log historical data, for example to keep track of employees’ previous salaries.
A triggering event can be an INSERT, UPDATE, or DELETE statement on a table.
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.
The trigger is mostly used for maintaining the integrity of the information on the database. For example, when a new record (representing a new worker) is added to the employees table, new records should also be created in the tables of the taxes, vacations and salaries.
Triggers can also be used to log historical data, for example to keep track of employees’ previous salaries.
Correct Answer: D
Question 1 Explanation:
A triggering event or statement is the SQL statement that causes a trigger to be fired.
A triggering event can be an INSERT, UPDATE, or DELETE statement on a table.
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.
The trigger is mostly used for maintaining the integrity of the information on the database. For example, when a new record (representing a new worker) is added to the employees table, new records should also be created in the tables of the taxes, vacations and salaries.
Triggers can also be used to log historical data, for example to keep track of employees’ previous salaries.
A triggering event can be an INSERT, UPDATE, or DELETE statement on a table.
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.
The trigger is mostly used for maintaining the integrity of the information on the database. For example, when a new record (representing a new worker) is added to the employees table, new records should also be created in the tables of the taxes, vacations and salaries.
Triggers can also be used to log historical data, for example to keep track of employees’ previous salaries.
Subscribe
Login
0 Comments