Mysql Basic


  1. Without LOCAL, LOAD DATA is _________________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    LOAD DATA is more efficient without LOCAL. Without LOCAL, the file must be located on the server. The FILE privilege must be given. The server can read the file directly from disk.


  1. Which of the following is more efficient?
    LOAD DATA, INSERT











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, the ‘LOAD DATA’ in all forms is more efficient than the ‘INSERT’ because it loads rows in bulk. The server first parses then interprets only one statement instead of many.



  1. The function used to convert a string to an int is ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    In MySQL, the function used to convert a string to an integer is INET_ATON(). On the other hand, the function INET_NTOA() converts a string to the corresponding integer value.


  1. The function used to convert an int to string is ______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    In MySQL, the function used to convert an integer to a string is INET_NTOA(). On the other hand, the function INET_ATON() converts a string to the corresponding integer value.



  1. What is used to perform analysis of key values by the server?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, for the MyISAM and InnoDB tables, the server can be told to perform an analysis of key values by issuing the ANALYZE TABLE statement. It helps in knowing about query optimization.