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 column attribute provides unique numbers for identification is ______________ |
| A. | AUTO_INCREMENT |
| B. | UNSIGNED |
| C. | IDENTIFY |
| D. | DESCRIBE |
| Answer» B. UNSIGNED | |
| 2. |
Illegal values converted to the appropriate ‘zero’ value for ______________ |
| A. | Numeric |
| B. | String |
| C. | ENUM |
| D. | TIME |
| Answer» E. | |
| 3. |
The function returning reference to array of row values is ______________ |
| A. | fetchrow_array() |
| B. | fetchrow_arrayref() |
| C. | fetch() |
| D. | fetchrow_hashref() |
| Answer» C. fetch() | |
| 4. |
fetchrow_hashref() returns reference to hash of row values keyed by ______________ |
| A. | row name |
| B. | column name |
| C. | table name |
| D. | database name |
| Answer» C. table name | |
| 5. |
The function returning reference to hash of row values is ______________ |
| A. | fetchrow_array() |
| B. | fetchrow_arrayref() |
| C. | fetch() |
| D. | fetchrow_hashref() |
| Answer» E. | |
| 6. |
The function returning an array of row values is ______________ |
| A. | fetchrow_array() |
| B. | fetchrow_arrayref() |
| C. | fetch() |
| D. | fetchrow_hashref() |
| Answer» B. fetchrow_arrayref() | |
| 7. |
ILLEGAL_VALUES_CONVERTED_TO_THE_APPROPRIATE_‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚Àւ§ZERO‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ¬•_VALUE_FOR_______________?$# |
| A. | Numeric |
| B. | String |
| C. | ENUM |
| D. | TIME |
| Answer» E. | |
| 8. |
The_column_attribute_provides_unique_numbers_for_identification_is_______________$ |
| A. | AUTO_INCREMENT |
| B. | UNSIGNED |
| C. | IDENTIFY |
| D. | DESCRIBE |
| Answer» B. UNSIGNED | |
| 9. |
By default, MySQL does not clip out of range numeric values to the nearest fit value? |
| A. | True |
| B. | False |
| Answer» C. | |
| 10. |
What is the maximum non zero values for DOUBLE? |
| A. | ±1.7976931348623157E+307 |
| B. | ±1.7976931348623157E+308 |
| C. | ±1.7976931348623157E+306 |
| D. | ±1.7976931348623157E+305 |
| Answer» C. ¬¨¬®¬¨¬±1.7976931348623157E+306 | |
| 11. |
What is the maximum non zero value for FLOAT? |
| A. | 3.402823466E+38 |
| B. | 3.402823466E+37 |
| C. | 3.402823466E+39 |
| D. | 3.402823466E+35 |
| Answer» B. 3.402823466E+37 | |
| 12. |
RTF refers to ______________ |
| A. | Rich Text Format |
| B. | Right Text Format |
| C. | Rich Text Function |
| D. | Right Text Function |
| Answer» B. Right Text Format | |