MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 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. |
_____________TRIGGERS_DO_NOT_CREATE_THE_SPECIAL_INSERTED_AND_DELETED_TABLES.?$ |
| A. | DML |
| B. | CLR |
| C. | DDL |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 2. |
Scope_of_DDL_triggers_in_SQL_Server_can_be_:$ |
| A. | Server |
| B. | Client |
| C. | Views |
| D. | None of the mentioned |
| Answer» B. Client | |
| 3. |
How many types of DDL Trigger is present in SQL Server ? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |
| 4. |
DDL triggers can only fire after the ______ statement has occurred. |
| A. | DML |
| B. | CLR |
| C. | DDL |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 5. |
Purpose of DDL Trigger is to : |
| A. | Perform administrative tasks |
| B. | Audit |
| C. | Regulating database operations. |
| D. | All of the mentioned |
| Answer» E. | |
| 6. |
INSTEAD of clause cannot be used for ____________ trigger. |
| A. | DML |
| B. | DDL |
| C. | LOGON |
| D. | CLR |
| Answer» C. LOGON | |
| 7. |
DDL triggers can be applied to __________ statement. |
| A. | CREATE |
| B. | UPDATE |
| C. | DELETE |
| D. | INSERT |
| Answer» B. UPDATE | |
| 8. |
_____________ is special type of trigger based on CLR environment. |
| A. | DML |
| B. | DDL |
| C. | LOGON |
| D. | CLR |
| Answer» E. | |