MySQL Database Operations


  1. The higher priority is ______________.
    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.


  1. What is the default size of ‘max_binlog_cache_size’ system variable?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    The max_binlog_cache_size system variable can be used to restrict the total size used to cache a multiple-statement transaction. If transaction is larger than this it fails and rolls back.



  1. The metadata log is _______________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The DDL log is also known as the metadata log. The metadata operations performed by the DDL statements. The Relay Log has the data changes received from a replication master server written in it.


  1. What is the log in which data changes received from a replication master server are written?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    The Relay Log has the data changes received from a replication master server written in it. The problems encountered during the starting, running or stopping of ‘mysqld’ is written in error log.



  1. Multiple MySQL servers can be run on the same machine.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    It is useful to run multiple servers on the same machine under certain circumstances. A new MySQL release can also be tested while leaving the current production server in place.