Mysql Compound Statements


  1. What can be used interchangeably with MYSQL_VERSION_ID?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The ‘LIBMYSQL_VERSION’ and ‘LIBMYSQL_VERSION_ID’ macros have the same values as ‘MYSQL_SERVER_VERSION’ and ‘MYSQL_VERSION_ID’ and the two sets of macros can be used interchangeably.


  1. What can be used in place of MYSQL_SERVER_VERSION?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The macros ‘LIBMYSQL_VERSION’ and ‘LIBMYSQL_VERSION_ID’ have the same values as ‘MYSQL_SERVER_VERSION’ and ‘MYSQL_VERSION_ID’ and the two sets of macros can be used in place of each other.


  1. When linking to a static MySQL C client library, the client library and the client application can use different compiler options.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    Generally, when linking to a static MySQL C client library, the client library and the client application must use the same compiler option when it is required to link the C runtime.


  1. What does ‘mysql_query()’ return on failure?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    Both of the functions named ‘mysql_query()’ and ‘mysql_real_query()’ return zero for statements that succeed. They return non zero for failure. A statement is successfully executed if the server accepts it.


  1. What is the exec_stmt_ssl written in?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    In MySQL, the ‘sampdb’ distribution contains a source file named ‘exec_stmt_ssl.c’ from which the client program ‘exec_stmt_ssl’ can be built. There is a procedure to build this file.