answersLogoWhite

0

A database trigger is an action that the database management software will perform automatically when a preset list of conditions are met. Different database vendors have different mechanisms in place for the declaration of triggers, but the principles remain the same.

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Trigonometry

What means or by whom is a trigger executed?

A trigger is executed by a database management system (DBMS) in response to specific events on a table or view, such as INSERT, UPDATE, or DELETE operations. It is defined using a set of SQL statements that automatically run when the specified event occurs. Triggers are often used to enforce business rules, maintain data integrity, or automate system tasks without requiring explicit calls from applications.


What is meant by trigger in database?

Database trigger is a procedural code that occurs in response to an event of a table of a database. for ex if any row is added in employee table, new records should also be added in salaries table.


What is a trigger in dbms?

Trigger is a statement that is automatically executed by the system as a side effect of a modification to the database. Several existing systems have their own non standard trigger functions. For a trigger we need to specify the condition under which the trigger is executed.


How pyramids traps work?

Pyramid traps, often featured in adventure games and movies, typically involve a mechanism that triggers when someone enters the pyramid or steps on a certain pressure plate. This can activate various traps, such as falling stones, dart shooters, or hidden spikes. The design usually relies on ancient engineering principles, using gravity and simple levers or pulleys to create a deadly surprise for intruders. The concept plays on themes of tomb protection and the desire to safeguard treasures from grave robbers.


Related Questions

What is the Oracle Developer Responsibility?

SQL, PL/SQL, Forms and Reports Development, Database Design, Stored Procedures, Functions, Triggers


Is SQL a Database?

SQL is not Database, it is a Language used to communicate with Database...


How do you recover database file using sql server?

A SQL recovery tool (see below) will help you repair corrupted .mdf files, tables, views, stored procedures, rules, defaults, user defined data types and triggers from Microsoft SQL server database & effectively recover large SQL Server database. Recover sql server databases thanks to programmed method I would recommend you next utility


What database does facebook uses?

facebook uses "NO SQL" database "NO SQL" name is derived from first letters of NOT ONLY SQL


What is sql database?

An SQL database is one that implements the use of Structured Query Language to manage data stored in the database. SQL is the most used way of communicating with databases.


Is SQL An application to manage Data in a database?

SQL is a language broad term to define a type of database. More specific ones are My SQL (open source) and MicroSoft SQL


Give database for medical store system in SQL server 2005?

database for medical shop in sql


What does sql-99 mean?

SQL-99, officially known as SQL2, is an extension of the SQL (Structured Query Language) standard that was published in 1999. It introduced several new features and functionalities to enhance the language, including support for object-relational database management, triggers, and recursive queries. SQL-99 aimed to improve the expressiveness and flexibility of SQL, making it more powerful for complex data manipulation and retrieval. It is part of a series of SQL standards developed by ANSI and ISO to promote consistency and interoperability across database systems.


Difference between sql and sql plus?

SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database


Which SQL database products do not run on Linux?

The following is a list of SQL database systems that do not currently have a Linux version:4th DimensionMicrosoft SQL ServerOracle RdbR:BaseScimoreDB


Difference between SQL Exception class and SQL Warning class?

sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.


The types of languages a database system?

Database systems can support multiple types of languages, including data definition language (DDL) for defining database schema, data manipulation language (DML) for querying and updating data, and data control language (DCL) for managing access and permissions. Additionally, some database systems support procedural languages like PL/SQL or T-SQL for writing stored procedures and triggers.