MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
To how many of these does the LOW_PRIORITY modifier apply to?DELETE, INSERT, LOAD DATA, REPLACE |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| E. | None of these |
| Answer» B. 3 | |
| 2. |
How many of the following implement the default scheduling property of MySQL?MyISAM, MERGE, MEMORY |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» B. 2 | |
| 3. |
Which of these has higher priority?writes, reads |
| A. | reads |
| B. | same priority |
| C. | machine dependent |
| D. | writes |
| E. | None of these |
| Answer» E. None of these | |
| 4. |
The number of tables among the following for which HIGH_PRIORITY have an effect are _________________.MyISAM, MEMORY, MERGE |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» B. 2 | |
| 5. |
The number of tables for which DELAYED works is _________________.MyISAM, MEMORY, ARCHIVE, BLACKHOLE |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| E. | None of these |
| Answer» B. 3 | |
| 6. |
The number of tables for which DELAYED works is _________________. |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 1 |
| E. | None of these |
| Answer» B. 3 | |
| 7. |
The number of tables among the following for which HIGH_PRIORITY have an effect are _________________. |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» B. 2 | |