Menu
Home / CSE MCQs / DBMS MCQs :: Triggers - DBMS

CSE MCQs :: DBMS MCQs

DBMS MCQs - RDBMS
DBMS MCQs - DBMS Keys
DBMS MCQs - SQL Basics
DBMS MCQs - RAID - DBMS
DBMS MCQs - Views - DBMS
DBMS MCQs - Joins - DBMS
DBMS MCQs - OLAP - DBMS
DBMS MCQs - Indexes - DBMS
DBMS MCQs - DBMS Data Types
DBMS MCQs - Triggers - DBMS
DBMS MCQs - Deadlocks - DBMS
DBMS MCQs - Constraints - DBMS
DBMS MCQs - Aggregate Functions
DBMS MCQs - Normal Forms - DBMS
DBMS MCQs - Transactions - DBMS
DBMS MCQs - Relational Algebra - DBMS
DBMS MCQs - Storage Structure - DBMS
DBMS MCQs - Physical Storage Media - DBMS
  1. 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.
    2. A.
    Procedures
    B.
    Triggers
    C.
    Functions
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Trigger are supported in
    3. A.
    Delete
    B.
    Update
    C.
    Views
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. 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.
    4. A.
    for insert, on
    B.
    On, for insert
    C.
    For, insert
    D.
    Both a and c

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. What are the after triggers ?
    5. A.
    Triggers generated after a particular operation
    B.
    These triggers run after an insert, update or delete on a table
    C.
    These triggers run after an insert, views, update or delete on a table
    D.
    Both b and c

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. The variables in the triggers are declared using
    6. A.
    -
    B.
    @
    C.
    /
    D.
    /@

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. The default extension for an Oracle SQL*Plus file is:
    7. A.
    .txt
    B.
    .pls
    C.
    .ora
    D.
    .sql

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. Which of the following is NOT an Oracle-supported trigger?
    8. A.
    BEFORE
    B.
    DURING
    C.
    AFTER
    D.
    INSTEAD OF

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. What are the different in triggers ?
    9. A.
    Define, Create
    B.
    Drop, Comment
    C.
    Insert, Update, Delete
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Triggers ________ enabled or disabled
    10. A.
    Can be
    B.
    Cannot be
    C.
    Ought to be
    D.
    Always

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. Which prefixes are available to Oracle triggers?
    11. A.
    : new only
    B.
    : old only
    C.
    Both :new and : old
    D.
    Neither :new nor : old

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers