Mysql miscellaneous


  1. Which of these exports table definitions and contents?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, some distributions include a set of some client programs. ‘mysqldump’ exports the table definitions and the contents. ‘mysqladmin’ performs adminisitrative tasks.


  1. The system variable controls the size of the table cache _________________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, when the server opens table files it keeps them open to minimize the number of file-opening operations. It maintains information about open files in the table cache.



  1. Which of these is faster when accessing data?
    memory, disk











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    In MySQL, the administrators have more privileges since they have more control of the MySQL server or the machine on which it runs. Accessing data in memory is faster than from disk.


  1. The default scheduling property of MySQL is implemented by how many of these?
    MyISAM, MERGE, MEMORY











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The MyISAM, MERGE and the MEMORY storage engines implement the default scheduling policy of MySQL with the help of the table locks. Whenever a client accesses a table a lock for it must be acquired first.



  1. What has higher priority?
    writes, reads











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    A client performing an operation that modifies a table is a writer and the client that performs a retrieval from the table is a reader. The writes have higher priority than reads.