MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 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 date and time datatype that stores time value in hh:mm:ss format is ___________. |
| A. | TIMESTAMP |
| B. | DATETIME |
| C. | DATE |
| D. | TIME |
| E. | None of these |
| Answer» E. None of these | |
| 2. |
The datatype that means a variable length non binary string is __________. |
| A. | BLOB |
| B. | VARBINARY |
| C. | VARCHAR |
| D. | BINARY |
| E. | None of these |
| Answer» D. BINARY | |
| 3. |
The C in the ACID property of transactions is _______________. |
| A. | Consistency |
| B. | Collision |
| C. | Compound |
| D. | Concrete |
| E. | None of these |
| Answer» B. Collision | |
| 4. |
The A in the ACID property of transactions is _______________. |
| A. | Atomicity |
| B. | Accuracy |
| C. | Availability |
| D. | Adjustability |
| E. | None of these |
| Answer» B. Accuracy | |
| 5. |
If an error occurs during the transaction the troubleshoot is ____________. |
| A. | commit |
| B. | update |
| C. | delete |
| D. | rollback |
| E. | None of these |
| Answer» D. rollback | |
| 6. |
The variable which represents the default time zone of the MySQL server is _____________. |
| A. | date_and_time |
| B. | system_time |
| C. | time_zone |
| D. | system_time_zone |
| E. | None of these |
| Answer» D. system_time_zone | |
| 7. |
The system variable system_time_zone can be reset at runtime. |
| A. | False |
| B. | True |
| C. | NA |
| D. | NA |
| E. | NA |
| Answer» C. NA | |
| 8. |
The number of options that can be used to control LOCAL capability at runtime is _____________. |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» C. 1 | |
| 9. |
The spatial datatype used to store a curve is _____________. |
| A. | LINESTRING |
| B. | POLYGON |
| C. | GEOMETRY |
| D. | POINT |
| E. | None of these |
| Answer» B. POLYGON | |