MySQL Functions


  1. Converting a client/server application to embedded server is difficult.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    Writing an application that uses the embedded server is different from writing one that operates in a client/server context. A program that is written as a client/server application can easily be converted to use the embedded server.


  1. Which statement can produce the same output as ‘SHOW COLUMNS’?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The ‘DESCRIBE’ statement with a table name or view name produces the same kind of output as the ‘SHOW COLUMNS’ statement. The ‘SHOW’ entry can be referred to for further information.



  1. What sets up an association between one or more MyISAM tables and the named key cache?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    ‘CACHE INDEX’ sets up an association between one or more MyISAM tables and the named key cache which must already exist. The INDEX privilege is needed for each table named in the statement.


  1. The statement that alters an existing event to have the given definition is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The statement ‘ALTER EVENT’ alters an existing event to have the given definition. The ‘RENAME TO’ clause renames the event. The other clauses are described in the entry for ‘CREATE EVENT’.



  1. Which statement upgrades the database directory name encoding?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The statement ‘ALTER DATABASE’ changes database attributes or upgrades the database directory name encoding. It requires the ‘ALTER’ privilege for the database to be given.