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 ‘SOCKET’ protocol is permitted on which operating systems? |
| A. | all |
| B. | unix only |
| C. | windows only |
| D. | none |
| Answer» C. windows only | |
| 2. |
The –protocol value ‘TCP’ runs on which operating systems? |
| A. | all |
| B. | unix only |
| C. | windows only |
| D. | none |
| Answer» B. unix only | |
| 3. |
THE_‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚Àւ§SOCKET‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ¬•_PROTOCOL_IS_PERMITTED_ON_WHICH_OPERATING_SYSTEMS??$# |
| A. | all |
| B. | unix only |
| C. | windows only |
| D. | none |
| Answer» C. windows only | |
| 4. |
The –protocol value ‘TCP’ runs on which operating systems?# |
| A. | all |
| B. | unix only |
| C. | windows only |
| D. | none |
| Answer» B. unix only | |
| 5. |
Connections to remote servers always use TCP/IP. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
Which option is supplied to ensure TCP/IP connection to local server? |
| A. | –localhost |
| B. | –host |
| C. | –hostlocal |
| D. | –connectlocal |
| Answer» C. ‚Äö√Ñ√∂‚àö√ë‚àö¬®hostlocal | |
| 7. |
Which of the following can be used interchangeably with MYSQL_VERSION_ID? |
| A. | LIBMYSQL_VERSION |
| B. | LIBMYSQL_VERSION_ID |
| C. | MYSQL_VERSION_ID |
| D. | MYSQL_ID |
| Answer» C. MYSQL_VERSION_ID | |
| 8. |
Which of these can be used in place of MYSQL_SERVER_VERSION? |
| A. | LIBMYSQL_VERSION |
| B. | LIBMYSQL_VERSION_ID |
| C. | MYSQL_VERSION_ID |
| D. | MYSQL_ID |
| Answer» B. LIBMYSQL_VERSION_ID | |
| 9. |
When linking to a static MySQL C client library, the client library and the client application must use the same compiler option. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
mysql_init() returns a _____________ |
| A. | integer |
| B. | float |
| C. | structure |
| D. | pointer to a structure |
| Answer» E. | |
| 11. |
Which header should be included first? |
| A. | my_global.h |
| B. | my_sys.h |
| C. | mysql.h |
| D. | my_local.h |
| Answer» B. my_sys.h | |
| 12. |
Which library file contains various portability macros and definitions? |
| A. | my_global.h |
| B. | my_sys.h |
| C. | mysql.h |
| D. | my_local.h |
| Answer» C. mysql.h | |