MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 12 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. |
The default definer of an event is the user who _______________ |
| A. | created the database |
| B. | created the event |
| C. | created the table |
| D. | created the column |
| Answer» C. created the table | |
| 2. |
To create or drop events for a database, which privilege should be granted? |
| A. | CREATE |
| B. | DROP |
| C. | PRIVILEGE |
| D. | EVENT |
| Answer» E. | |
| 3. |
TO_CREATE_OR_DROP_EVENTS_FOR_A_DATABASE,_WHICH_PRIVILEGE_SHOULD_BE_GRANTED??$ |
| A. | CREATE |
| B. | DROP |
| C. | PRIVILEGE |
| D. | EVENT |
| Answer» E. | |
| 4. |
The_default_definer_of_an_event_is_the_user_who________________$ |
| A. | created the database |
| B. | created the event |
| C. | created the table |
| D. | created the column |
| Answer» C. created the table | |
| 5. |
Which clause specifies periodic execution at fixed intervals? |
| A. | EVERY |
| B. | ALL |
| C. | AT |
| D. | ALTERNATE |
| Answer» B. ALL | |
| 6. |
Which log does the event scheduler log to? |
| A. | error |
| B. | record |
| C. | library |
| D. | update |
| Answer» B. record | |
| 7. |
If the scheduler is stopped, no events run. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
Which value of event_scheduler enables checking status but not changing it at runtime? |
| A. | ON |
| B. | OFF |
| C. | DISABLED |
| D. | ENABLED |
| Answer» D. ENABLED | |
| 9. |
Which statement is used to check the status of the event scheduler at runtime? |
| A. | SHOW STATUS OF ‘event_scheduler’ |
| B. | SHOW VARIABLES OF ‘event_scheduler’ |
| C. | SHOW STATUS LIKE ‘event_scheduler’ |
| D. | SHOW VARIABLES LIKE ‘event_scheduler’ |
| Answer» E. | |
| 10. |
Which of the following lines is used to turn on the event scheduler? |
| A. | event_scheduler = ON |
| B. | eventscheduler = ON |
| C. | event_scheduler_ON |
| D. | events_scheduler_ON |
| Answer» B. eventscheduler = ON | |
| 11. |
The event scheduler does not run by default. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
Which of these is a stored program associated with a schedule? |
| A. | Trigger |
| B. | Event |
| C. | Stored function |
| D. | Stored procedure |
| Answer» C. Stored function | |