23 Questions
What is a trigger in the context of database management systems?
A set of SQL statements that are called automatically on a database server event
How are triggers different from stored procedures?
Stored procedures can receive parameters
Which statement is true about invoking triggers?
Triggers are invoked automatically during data modification events
What distinguishes a trigger from a stored procedure?
Receiving parameters in triggers
Why is a trigger considered a special procedure?
Because it cannot be invoked directly like a stored procedure
Which of the following accurately describes the role of triggers in database management systems?
Automatically performing actions on specific database events
What will the trigger display_salary_changes show when a record is created in the CUSTOMERS table with the values (7, 'Kriti', 22, 'HP', 7500.00)?
Old salary: New salary: 7500 Salary difference: 500
What does the UPDATE statement in the text do to the salary of the record with ID = 2 in the CUSTOMERS table?
Adds 500 to the current salary
Which timing point does a Compound Trigger in Oracle support to specify actions?
AFTER STATEMENT – level
What is the purpose of the DROP TRIGGER command in Oracle?
Deletes a trigger
What does a DML operation on the CUSTOMERS table refer to?
Database Modification Language operation
In the INSERT INTO statement provided, what data type is used for the 'SALARY' field?
Float
What is the purpose of a trigger in Oracle?
To execute a set of actions automatically in response to a specific database event
What is the purpose of the 'CREATE TRIGGER' statement in Oracle?
To define a new trigger for the database
Why must the trigger name be unique in Oracle?
To prevent conflicts and ensure each trigger can be identified uniquely
Which keyword is used to specify when a trigger will be executed in Oracle?
WHEN
What type of trigger fires before the specified event has occurred in Oracle?
BEFORE Trigger
Which type of trigger fires for each record affected in a specified event, specifically for DML events?
Row level trigger
What is one of the benefits of triggers mentioned in the text that involves generating derived column values automatically?
Event logging
In the given example, what does the trigger 'sample_trigger' do before an INSERT operation on the 'student' table?
Sets the total column to the marks divided by 6 for the new record
What is the purpose of the trigger 'display_salary_changes' in the provided code snippet?
Display changes in salary when there is a delete operation on the customers table
Which type of trigger fires when a DDL event like CREATE or ALTER is specified?
DDL trigger
What action does the 'display_salary_changes' trigger perform BEFORE DELETE OR INSERT OR UPDATE operations on the customers table?
Calculate and display salary differences for the affected record
Learn about various types of triggers in database management such as ROW level, DML, DDL, and DATABASE triggers. Explore how each trigger type functions based on different events like record changes, DML operations, DDL commands, and database events.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free