PL SQL Practice Test 10
Which is not a type of trigger?
- DDL
- DML
- DCL
- Database
Ans : 3
Which prefixes are available to Oracle triggers?
- : new only
- : old only
- Both: new and : old
- Neither: new nor :old
Ans : 3
Triggers ________ enabled or disabled
- Can be
- Cannot be
- Ought to be
- Always
Ans : 1
What are the after triggers?
- Triggers generated after a particular operation
- These triggers run after an insert, update or delete on a table
- These triggers run after an insert, views, update or delete on a table
- 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.
- ALTER TABLE statement
- DROP TABLE statement
- DELETE TABLE statement
- none of the mentioned
Ans : 1
Which of the following is not a typical trigger action ?
- Insert
- Select
- Delete
- Delete
Ans : 2
Which data dictionary triggers are available in Database?
- USER_TRIGGERS
- USER_TABLES
- ALL_USER_TRIGGERS
- TABLE_TRIGGERS
Ans : 1
Which command do you use to remove the trigger?
- DROP TRIGGER business_hour;
- DELETE TRIGGER business_hour;
- REMOVE TRIGGER business_hour;
- ALTER TRIGGER business_hour REMOVE;
Ans : 1
A CALL statement inside the trigger body enables you to call ______.
- A package.
- A stored function.
- A stored procedure.
- 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?
- Table
- DML event
- Package name and body
- Trigger timing
Ans : 3
Which of the following is not true about PL/SQL triggers?
- Triggers are stored programs.
- They are automatically executed or fired when some events occur.
- Triggers could be defined on the table, view, schema, or database with which the event is associated.
- None of the above.
Ans : 4
What are the different events in Triggers?
- Define, Create
- Drop, Comment
- Insert, Update, Delete
- All of the above
Ans : 3
Which of the following is true for querying a table in the same trigger?
- The AFTER keyword should be used
- The BEFORE keyword should be used
- None of the points in a. and b.
- 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.
- ON
- USING
- Where
- None of the above
Ans : 1
The variables in the triggers are declared using
- –
- @
- /
- /@
Ans : 2
Point out the correct statement:
- Triggers are database object
- Five types of triggers are present in Oracle
- A DDL trigger is an action programmed to execute when a DML event occurs in the database server
- None of the mentioned
Ans : 1
INSTEAD of clause cannot be used for ____________ trigger.
- DML
- DDL
- A &B
- None of the above
Ans : 2
Point out the wrong statement:
- We can have an INSTEAD OF insert/update/delete trigger on a table that successfully executed
- DML Triggers are used to evaluate data after data manipulation using DML statements
- INSTEAD OF triggers cause their source DML operation to skip
- 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?
- Inside a package
- Inside a PL/SQL block
- At the schema level
- Inside a trigger
Ans : 4
What is the maximum size of a trigger?
- 32KB
- 64KB
- 16KB
- 8KB
Ans : 1
Attend Free Demo and Learn SQL SERVER ONLINE TRAINING by Real-Time Expert
Read More PL/SQL Objective Questions and Answers