Mysql Setup


  1. What is the storage size in bytes required for the MEDIUMINT datatype?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    The numeric datatypes used in MySQL vary over ranges. There are a variety of INT types in the type specification. TINYINT requires 1, SMALLINT requires 2 bytes and MEDIUMINT requires 3.


  1. How many options can be used to control LOCAL capability at runtime?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    At runtime, the server can be started with the ‘–local-infile’ or ‘–skip-local-infile’ options to enable or disable ‘LOCAL’ capability on the server side. It can be enabled at build time too.



  1. The log enabled by –relay-log-index is _____________











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The system variable ‘time_zone’ represents the default time zone of the MySQL server. By default, this variable is set to ‘SYSTEM’ which means to use the system_time_zone setting.


  1. The option that supplies the pathname to root directory of MySQL installation is _____________.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    The option ‘–basedir’ has the purpose to specify the pathname to the root directory of the MySQL installation. The pathname to the data directory is specified by the option ‘–datadir’.



  1. OS imposes per process limits on the number of open file descriptors.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    OS imposes per process limits on the number of open file descriptors. If the system makes it difficult to raise the limit, running multiple instances of the server binary is done.