Quiz


1:

The parameter that controls how much memory is used to store indexes for InnoDB is

  1. key_buffer_size

  2. innodb_buffer_pool_size

  3. innodb_key_buffer_size

  4. read_buffer_size

2:

The parameter that controls how much memory is used to cache table data for InnoDB is

  1. key_buffer_size

  2. innodb_buffer_pool_size

  3. innodb_key_buffer_size

  4. read_buffer_size

3:

The parameter that controls how much memory is used to cache table data for MyISAM is

  1. key_buffer_size

  2. table_cache

  3. innodb_key_buffer_size

  4. read_buffer_size

4:

The parameter that controls how much memory is used to cache index data for MyISAM is

  1. key_buffer_size

  2. table_cache

  3. innodb_key_buffer_size

  4. read_buffer_size

5:

The read_buffer_size parameter should not be made too large because

  1. if many threads are performing full scans , you will have a problem

  2. it is always possible to add more indexes so that MySQL will never need to do a full table scan

  3. it wastes disk space

  4. none of the above




MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net