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. |
When no modes are enabled, what does this SQL statement return? |
| A. | empty value |
| B. | zero |
| C. | a negative value |
| D. | a garbage valueView Answer |
| Answer» B. zero | |
| 2. |
Which statement can be used to specify the sql_mode system variable at runtime? |
| A. | SPECIFY |
| B. | SET |
| C. | ASSIGN |
| D. | CHANGE |
| Answer» C. ASSIGN | |
| 3. |
WHICH_STATEMENT_CAN_BE_USED_TO_SPECIFY_THE_SQL_MODE_SYSTEM_VARIABLE_AT_RUNTIME??$ |
| A. | SPECIFY |
| B. | SET |
| C. | ASSIGN |
| D. | CHANGE |
| Answer» C. ASSIGN | |
| 4. |
Which statement can be used to specify the sql_mode system variable at runtime?$ |
| A. | SPECIFY |
| B. | SET |
| C. | ASSIGN |
| D. | CHANGE |
| Answer» C. ASSIGN | |
| 5. |
Which of the following commands sets the SQL mode as TRADITIONAL? |
| A. | –sqlmode=’TRADITIONAL’ |
| B. | –sql_mode=’TRADITIONAL’ |
| C. | –sql-mode=’TRADITIONAL’ |
| D. | –sql.mode=’TRADITIONAL’ |
| Answer» D. ‚Äö√Ñ√∂‚àö√ë‚àö¬®sql.mode=‚Äö√Ñ√∂‚àö√ë‚àö¬•TRADITIONAL‚Äö√Ñ√∂‚àö√ë‚àö¬• | |
| 6. |
MySQL server mode values are case sensitive. |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
Which of these modes is a composite server mode? |
| A. | COMPOSITE |
| B. | COMPOSITE_MODE |
| C. | COMPOSITE_SERVER |
| D. | ANSI |
| Answer» E. | |
| 8. |
Which mode tells the server to recognize || as the string concatenation operator? |
| A. | PIPES_AS_CONCAT |
| B. | ORS_AS_CONCAT |
| C. | DOUBLE_PIPE_AS_CONCAT |
| D. | LOGIC_OR_AS_CONCAT |
| Answer» B. ORS_AS_CONCAT | |
| 9. |
Which mode tells the server to recognize double quote as an identifier quoting character? |
| A. | ANSI_DQ |
| B. | ANSI_QUOTES |
| C. | ANSI_RECG_QUOTES |
| D. | ANSI_RECG_DQUOTES |
| Answer» C. ANSI_RECG_QUOTES | |
| 10. |
How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data? |
| A. | reject them |
| B. | accept them |
| C. | change them to the closest legal value and accept |
| D. | change them to the closest legal value and reject |
| Answer» B. accept them | |
| 11. |
Any client in the client/server architecture of MySQL can change how the server behaves in relation to itself without impact on other clients. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
The system variable in MySQL server that enables to configure the SQL mode is __________ |
| A. | sql_config |
| B. | sql_mode |
| C. | sql_server |
| D. | sql_enable |
| Answer» C. sql_server | |