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. |
DDL_TRIGGER_CAN_CAPTURE_THE_INFORMATION_ABOUT_THE_EVENT_THAT_FIRED_IT_BY_USING____________FUNCTION.?$ |
| A. | EVENTDATA() |
| B. | EVENT() |
| C. | EVENTS() |
| D. | None of the mentioned |
| Answer» B. EVENT() | |
| 2. |
Which_of_the_following_database_level_event_si_raised_whenever_a_REFERENCES_permission_is_checked.$ |
| A. | EXECUTE |
| B. | REFERENCES |
| C. | UPDATE |
| D. | SELECT |
| Answer» C. UPDATE | |
| 3. |
You can use the handy event name of __________ to make sure your trigger covers all DDL events? |
| A. | DDL_DATABASE_EVENTS |
| B. | DDL_DATABASE_LEVEL_EVENTS |
| C. | DDL_DATABASE_LEVEL |
| D. | All of the mentioned |
| Answer» C. DDL_DATABASE_LEVEL | |
| 4. |
__________ could potentially lead to large audit records. |
| A. | DATABASE_OBJECT_ACCESS_GROUP |
| B. | DATABASE_MIRRORING_LOGIN_GROUP |
| C. | DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP |
| D. | DATABASE_OBJECT_PERMISSION_CHANGE_GROUP |
| Answer» B. DATABASE_MIRRORING_LOGIN_GROUP | |
| 5. |
AUDIT_CHANGE_GROUP event is raised whenever any audit is : |
| A. | Created |
| B. | Modified |
| C. | Delete |
| D. | All of the mentioned |
| Answer» E. | |
| 6. |
Which of the following is server-level audit action group? |
| A. | BACK_RESTORE_GROUP |
| B. | BACKUP_RESTORE_GROUP |
| C. | DB_LOGOUT_GROUP |
| D. | None of the mentioned |
| Answer» C. DB_LOGOUT_GROUP | |
| 7. |
Which of the following event is not intrinsically audited? |
| A. | ALTER DATABASE AUDIT SPECIFICATION |
| B. | CREATE SERVER AUDIT SPECIFICATION |
| C. | DROP SERVER AUDIT SPECIFICATION |
| D. | All of the mentioned |
| Answer» E. | |
| 8. |
How many ways of auditing the schema is available in SQL Server? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» B. 3 | |