MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
WHICH_OF_THE_FOLLOWING_IS_NOT_A_TYPICAL_TRIGGER_ACTION_??$ |
| A. | Insert |
| B. | Select |
| C. | Delete |
| D. | All of the mentioned |
| Answer» C. Delete | |
| 2. |
Triggers can be enabled or disabled with the ________ statement.$ |
| A. | ALTER TABLE statement |
| B. | DROP TABLE statement |
| C. | DELETE TABLE statement |
| D. | None of the mentioned |
| Answer» B. DROP TABLE statement | |
| 3. |
Triggers created with FOR or AFTER keywords is ? |
| A. | AFTER |
| B. | INSTEAD OF |
| C. | CLR |
| D. | All of the mentioned |
| Answer» B. INSTEAD OF | |
| 4. |
DML triggers in SQL Server is applicable to : |
| A. | Insert |
| B. | Update |
| C. | Delete |
| D. | All of the mentioned |
| Answer» E. | |
| 5. |
AFTER trigger in SQL Server can be applied to : |
| A. | Table |
| B. | Views |
| C. | Table and Views |
| D. | function |
| Answer» D. function | |
| 6. |
How many types of triggers are present in SQL Server ? |
| A. | 4 |
| B. | 5 |
| C. | 8 |
| D. | 9 |
| Answer» B. 5 | |
| 7. |
Trigger is special type of __________ procedure. |
| A. | Stored |
| B. | Function |
| C. | View |
| D. | Table |
| Answer» B. Function | |