PL SQL Practice Test 10

PL SQL Practice Test 10

PL-SQL-Objective-Questions-NareshIT

Which is not a type of trigger?

  1. DDL
  2. DML
  3. DCL
  4. Database

Ans :  3


Which prefixes are available to Oracle triggers?

  1. : new only
  2. : old only
  3. Both: new and : old
  4. Neither: new nor :old

Ans : 3


 Triggers ________ enabled or disabled

  1. Can be
  2.  Cannot be
  3. Ought to be
  4. Always

Ans : 1


What are the after triggers?

  1.  Triggers generated after a particular operation
  2. These triggers run after an insert, update or delete on a table
  3. These triggers run after an insert, views, update or delete on a table
  4. Both b and c

Ans : 2


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

1.BEFORE
2.DURING
3.AFTER
4.INSTEAD OF

Ans : 2


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


Triggers can be enabled or disabled with the ________ statement.

  1. ALTER TABLE statement
  2. DROP TABLE statement
  3. DELETE TABLE statement
  4. none of the mentioned

Ans : 1


Which of the following is not a typical trigger action ?

  1. Insert
  2. Select
  3. Delete
  4. Delete

Ans :  2


Which data dictionary triggers are available in Database?

  1. USER_TRIGGERS
  2. USER_TABLES
  3. ALL_USER_TRIGGERS
  4. TABLE_TRIGGERS

Ans : 1


Which command do you use to remove the trigger?

  1. DROP TRIGGER business_hour;
  2. DELETE TRIGGER business_hour;
  3. REMOVE TRIGGER business_hour;
  4. ALTER TRIGGER business_hour REMOVE;

Ans : 1


A CALL statement inside the trigger body enables you to call ______.

  1. A package.
  2. A stored function.
  3. A stored procedure.
  4. Another database trigger.

Ans : 3


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


The number of cascading triggers is limited by which data base initialization parameter?

Ans : 2


 You need to create a DML trigger. Which is not needed?

  1. Table
  2. DML event
  3. Package name and body
  4. Trigger timing

Ans : 3


Which of the following is not true about PL/SQL triggers?

  1. Triggers are stored programs.
  2. They are automatically executed or fired when some events occur.
  3. Triggers could be defined on the table, view, schema, or database with which the event is associated.
  4. None of the above.

Ans : 4


 What are the different events in Triggers?

  1. Define, Create
  2. Drop, Comment
  3. Insert, Update, Delete
  4. All of the above

Ans : 3


 Which of the following is true for querying a table in the same trigger?

  1. The AFTER keyword should be used
  2. The BEFORE keyword should be used
  3. None of the points in a. and b.
  4. Both of the points in a. and b.

Ans : 1


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


THE _____ clause specifies the table name on which the trigger is to be attached.

  1. ON
  2. USING
  3. Where
  4. None of the above

Ans : 1


 The variables in the triggers are declared using

  1. @
  2. /
  3. /@

Ans : 2


Point out the correct statement:

  1. Triggers are database object
  2. Five types of triggers are present in Oracle
  3. A DDL trigger is an action programmed to execute when a DML event occurs in the database server
  4. None of the mentioned

Ans :  1


INSTEAD of clause cannot be used for ____________ trigger.

  1. DML
  2. DDL
  3. A &B
  4. None of the above

Ans : 2


Point out the wrong statement:

  1. We can have an INSTEAD OF insert/update/delete trigger on a table that successfully executed
  2. DML Triggers are used to evaluate data after data manipulation using DML statements
  3. INSTEAD OF triggers cause their source DML operation to skip
  4. AFTER triggers cause their source DML operation to skip

Ans : 4


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


In which of the following can a subprogram NOT be created?

  1. Inside a package
  2. Inside a PL/SQL block
  3. At the schema level
  4. Inside a trigger

Ans : 4


What is the maximum size of a trigger?

  1. 32KB
  2. 64KB
  3. 16KB
  4. 8KB

Ans : 1


Attend Free Demo and Learn   SQL SERVER ONLINE TRAINING   by Real-Time Expert


Read More PL/SQL Objective Questions and Answers

Click Here
Click Here
Click Here
PL/SQL Objectives 1
PL/SQL Objectives 2
PL/SQL Objectives 3
PL/SQL Objectives 4
PL/SQL Objectives 5
PL/SQL Objectives 6
PL/SQL Objectives 7
PL/SQL Objectives 8
PL/SQL Objectives 9
PL/SQL Objectives 10
PL/SQL Objectives 11
PL/SQL Objectives 12
PL/SQL Objectives 13
PL/SQL Objectives 14
PL/SQL Objectives 15

Share this post