310-810.pdf - mySQL 310-810 Sun Certified MySQL 5.0...

This preview shows page 1 - 3 out of 5 pages.

310-810 mySQL Sun Certified MySQL 5.0 Database(R) Administrator Part 1
A. shell>mysql test < dump.sql B. shell>mysqladmin recover test dump.sql C. mysql> USE test;mysql> SOURCE dump.sql; D. mysql> RECOVER test dump.sql; Answer: A,C QUESTION:132 You have created a dump using mysqldump with the --extended-insert option. Will you be able to use this dump on any MySQL server instance? A. Always B. Yes, provided that --max-allowed-packet is set correctly C. Yes, provided that binary logging is turned off during the re-reading of the dump. D. No, the new server instance must be the same version as the one which created the dump for everything to work Answer:B QUESTION:133 The MySQL server host crashes at 10:00 in the morning, and is brought back online at 10:30. In order to ensure that all data are consistent, a copy is first made of the table, tablespace and log files currently on the server host, and these files are then restored from a backup made at 03:00 the same morning. What should be done in order to bring the database to the state it was at just before the server host crashed?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture