MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The number of languages that have interfaces to bind to the C API of MySQL among these is ______________.
|
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» B. 2 | |
| 2. |
The context in which the privilege CREATE TABLESPACE applies is ______________. |
| A. | Tables |
| B. | Views |
| C. | Server administration |
| D. | Stored routines |
| E. | None of these |
| Answer» D. Stored routines | |
| 3. |
MySQL uses security based on ACL which stands for ______________. |
| A. | Automatic Control Lists |
| B. | Automatic Control Language |
| C. | Access Control Language |
| D. | Access Control Lists |
| E. | None of these |
| Answer» E. None of these | |
| 4. |
The language in which image processing is least simple is ______________. |
| A. | Perl |
| B. | C |
| C. | PHP |
| D. | Python |
| E. | None of these |
| Answer» C. PHP | |
| 5. |
Triggers are not supported for _____________. |
| A. | views |
| B. | insert |
| C. | update |
| D. | delete |
| E. | None of these |
| Answer» B. insert | |
| 6. |
The most general purpose language is ______________. |
| A. | Perl |
| B. | PHP |
| C. | C |
| D. | Python |
| E. | None of these |
| Answer» D. Python | |
| 7. |
The language that is the core for APIs and communication in MySQL is ______________. |
| A. | C++ |
| B. | Ruby |
| C. | Python |
| D. | C |
| E. | None of these |
| Answer» E. None of these | |
| 8. |
What does abc || xyz , when PIPES_AS_CONCAT is enabled, result in? |
| A. | xyzabc |
| B. | abcxyz |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» C. 1 | |
| 9. |
The number of languages that have interfaces to bind to the C API of MySQL among these is ______________. |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» B. 2 | |
| 10. |
The option necessary to compile a C program havin math functions is ______________. |
| A. | -lp |
| B. | -lq |
| C. | -lm |
| D. | -ln |
| E. | None of these |
| Answer» D. -ln | |
| 11. |
The statement that is used to check the status of the event scheduler at runtime is _____________. |
| A. | SHOW VARIABLES LIKE event_scheduler |
| B. | SHOW STATUS LIKE event_scheduler |
| C. | SHOW VARIABLES OF event_scheduler |
| D. | SHOW STATUS OF event_scheduler |
| E. | None of these |
| Answer» B. SHOW STATUS LIKE event_scheduler | |
| 12. |
The line that is not used to turn on the event scheduler is _________________. |
| A. | events_scheduler_ON |
| B. | event_scheduler = ON |
| C. | eventscheduler = ON |
| D. | event_scheduler_ON |
| E. | None of these |
| Answer» C. eventscheduler = ON | |
| 13. |
What does the expression 2 BETWEEN 2 AND 5 result in? |
| A. | False |
| B. | -1 |
| C. | 2 |
| D. | True |
| E. | None of these |
| Answer» E. None of these | |
| 14. |
The value of event_scheduler that enables checking status but not changing it at runtime is ______________. |
| A. | OFF |
| B. | DISABLED |
| C. | ENABLED |
| D. | ON |
| E. | None of these |
| Answer» C. ENABLED | |