MySQL Connectors and APIs


  1. Which of the following is used on Solaris?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The program ‘gcc’ is generally used on Unix. ‘clang’ is used on ‘OSX’ or ‘FreeBSD’. The ‘Sun Studio’ is used on Solaris. However, ‘gcc’ on Unix is a widely popular choice for client programs.


  1. The static C library client in Windows is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The code can be linked with either the dynamic or static C client library. On Windows, the static library is named ‘mysqlclient.lib’ and the dynamic library is named ‘libmysql.dll’.



  1. Which of these has a smaller memory footprint?
    Perl, PHP











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    A clearly significant difference between Perl and PHP is that Perl has a bigger memory footprint than PHP. Apache processes are larger with ‘mod_perl’ linked in than with ‘mod_php’.


  1. What can be used as an alternative to mysqlconfig?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The ‘pkg-config’ statement can be used as an alternative to the ‘mysql_config’ statement for obtaining information like compiler flags or to link libraries required to compile some MySQL applications.



  1. On Unix, linking uses dynamic libraries by default.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    On Unix, the linking process uses the dynamic libraries by default. In order to link to the static client library instead, its path name should be added to the link command to do the job.