MySQL Connectors and APIs


  1. The primary programming interface to MySQL is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    The primary programming interface to MySQL is the C API. It is used to implement some of the standard clients in the MySQL distribution including mysql, mysqladmin and mysqldump.


  1. Each language binding defines its own interface for accessing MySQL.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    Each language binding defines its own interface that dictates all the rules for accessing MySQL. Popular and useful programming languages like C++, Java, Python, PHP and others.



  1. For how many of the following do interfaces exist for implementing direct native client-server protocol?
    Java, PHP, Ruby











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    There are interfaces for languages like Java, PHP and Python that implement the native client-server protocol directly instead of using the C library to handle communications.


  1. Which language is the core for APIs and communication in MySQL?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    In order to provide application development, MySQL provides a client library written in the C programming language. It enables the access of MySQL databases from a C program.



  1. How many of these languages have interfaces to bind to the C API of MySQL?
    Perl, PHP, Python











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The client library provides the means through which the MySQL bindings for other languages can be built on top of the C API. This type of interface exists for Perl, PHP, Python and others.