MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 19 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is ghi in the following MySQL statement? |
| A. | trigger name |
| B. | table name |
| C. | trigger statement |
| D. | update statementView Answer |
| Answer» D. update statementView Answer | |
| 2. |
What is def in the following MySQL statement? |
| A. | trigger name |
| B. | table name |
| C. | trigger statement |
| D. | update statementView Answer |
| Answer» C. trigger statement | |
| 3. |
What is abc in the following MySQL statement? |
| A. | trigger name |
| B. | table name |
| C. | trigger statement |
| D. | update statementView Answer |
| Answer» B. table name | |
| 4. |
Which statement is used to remove a trigger? |
| A. | REMOVE |
| B. | DELETE |
| C. | DROP |
| D. | CLEAR |
| Answer» D. CLEAR | |
| 5. |
Triggers enable to enforce data integrity constraints. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
WHICH_PREFIXES_ARE_AVAILABLE_TO_ORACLE_TRIGGERS??$ |
| A. | : new only |
| B. | : old only |
| C. | Both :new and : old |
| D. | Neither :new nor : old |
| Answer» D. Neither :new nor : old | |
| 7. |
trigger_name$ |
| A. | table name |
| B. | trigger statement |
| C. | update statement |
| Answer» C. update statement | |
| 8. |
Triggers ________ enabled or disable? |
| A. | Can be |
| B. | Cannot be |
| C. | Ought to be |
| D. | Always |
| Answer» B. Cannot be | |
| 9. |
trigger nam? |
| A. | table name |
| B. | trigger statement |
| C. | update statement |
| Answer» C. update statement | |
| 10. |
What are the different in triggers? |
| A. | Define, Create |
| B. | Drop, Comment |
| C. | Insert, Update, Delete |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 11. |
The TRIGGER privilege is used for the table to be able to create and drop triggers for it. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
Before MySQL 5.1.6 which privilege was required to create and drop triggers? |
| A. | PRIVILEGE |
| B. | TRIGGER |
| C. | SUPER |
| D. | MACRO |
| Answer» D. MACRO | |
| 13. |
The variables in the triggers are declared using |
| A. | – |
| B. | @ |
| C. | / |
| D. | /@ |
| Answer» C. / | |
| 14. |
What are the after triggers? |
| 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. | All of the mentioned |
| Answer» C. These triggers run after an insert, views, update or delete on a table | |
| 15. |
For which of the following are triggers not supported? |
| A. | delete |
| B. | update |
| C. | insert |
| D. | views |
| Answer» E. | |
| 16. |
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. |
| A. | for insert, on |
| B. | On, for insert |
| C. | For, insert |
| D. | None of the mentioned |
| Answer» C. For, insert | |
| 17. |
Which statement is used to create a trigger? |
| A. | CREATE TRIGGER |
| B. | CREATE TRIGGERS |
| C. | PRODUCE TRIGGER |
| D. | PRODUCE TRIGGERS |
| Answer» B. CREATE TRIGGERS | |
| 18. |
Triggers are supported in |
| A. | Delete |
| B. | Update |
| C. | Views |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 19. |
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. |
| A. | Procedures |
| B. | Triggers |
| C. | Functions |
| D. | None of the mentioned |
| Answer» C. Functions | |