MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 15 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 spatial datatype used to store a curve is _____________ |
| A. | GEOMETRY |
| B. | POINT |
| C. | LINESTRING |
| D. | POLYGON |
| Answer» D. POLYGON | |
| 2. |
The date and time datatype that stores time value in ‘hh:mm:ss’ format is ___________ |
| A. | DATE |
| B. | TIME |
| C. | DATETIME |
| D. | TIMESTAMP |
| Answer» C. DATETIME | |
| 3. |
The datatype that means a variable length non binary string is __________ |
| A. | VARCHAR |
| B. | BINARY |
| C. | VARBINARY |
| D. | BLOB |
| Answer» B. BINARY | |
| 4. |
The ‘C’ in the ACID property of transactions is _______________ |
| A. | Compound |
| B. | Concrete |
| C. | Collision |
| D. | Consistency |
| Answer» E. | |
| 5. |
The ‘A’ in the ACID property of transactions is _______________ |
| A. | Availability |
| B. | Accuracy |
| C. | Adjustability |
| D. | Atomicity |
| Answer» E. | |
| 6. |
The system variable ‘system_time_zone’ can be reset at runtime. |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
THE_DATE_AND_TIME_DATATYPE_THAT_STORES_TIME_VALUE_IN_‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚Àւ§HH:MM:SS‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ¬•_FORMAT_IS____________?$# |
| A. | DATE |
| B. | TIME |
| C. | DATETIME |
| D. | TIMESTAMP |
| Answer» C. DATETIME | |
| 8. |
The_spatial_datatype_used_to_store_a_curve_is______________$ |
| A. | GEOMETRY |
| B. | POINT |
| C. | LINESTRING |
| D. | POLYGON |
| Answer» D. POLYGON | |
| 9. |
The datatype that means a variable length non binary string is _________? |
| A. | VARCHAR |
| B. | BINARY |
| C. | VARBINARY |
| D. | BLOB |
| Answer» B. BINARY | |
| 10. |
The ‘A’ in the ACID property of transactions is _______________$ |
| A. | Availability |
| B. | Accuracy |
| C. | Adjustability |
| D. | Atomicity |
| Answer» E. | |
| 11. |
If an error occurs during the transaction the troubleshoot is ____________ |
| A. | delete |
| B. | rollback |
| C. | commit |
| D. | update |
| Answer» C. commit | |
| 12. |
The number of options that can be used to control LOCAL capability at runtime is _____________ |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» D. 3 | |
| 13. |
The variable which represents the default time zone of the MySQL server is _____________ |
| A. | time_zone |
| B. | system_time_zone |
| C. | date_and_time |
| D. | system_time |
| Answer» B. system_time_zone | |
| 14. |
The system variable ‘system_time_zone’ can be reset at runtime.$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 15. |
The server sets its default time zone by examining its environment. |
| A. | True |
| B. | False |
| Answer» B. False | |