Quiz


1:

If you want to back up your database, it is necessary to

  1. take down the server

  2. lock and flush the tables

  3. both a) and b)

  4. none of the above

2:

You should lock tables manually before executing

  1. a manual backup

  2. mysqldump

  3. mysqlhotcopy

  4. none of the above

3:

Which table types can you check with CHECK TABLE ?

  1. InnoDB and MyISAM

  2. MyISAM only

  3. MyISAM and BDB

  4. InnoDB and BDB

4:

Which table types can you repair with REPAIR TABLE ?

  1. InnoDB and MyISAM

  2. MyISAM only

  3. MyISAM and BDB

  4. InnoDB and BDB

5:

If CHECK TABLE reports Table is already up to date

  1. you need to run REPAIR TABLE

  2. the storage engine is not supported by CHECK TABLE

  3. the table is fine

  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