RRB JE (IT): DBMS fundamentals Quiz 4

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

What are the after triggers?

The variables in the triggers are declared using

The default extension for an Oracle SQL*Plus file is:

Which of the following is NOT an Oracle-supported trigger?

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

Triggers are not supported in

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

Course(course_id,sec_id,semester)

Here the course_id,sec_id and semester are __________ and course is a _________

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.