310-810.pdf - mySQL 310-810 Sun Certified MySQL 5.0 Database(R Administrator Part 1 http\/killexams.com\/exam-detail\/310-810 A shell>mysql test < dump.sql

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
Image of page 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?
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 5 pages?

  • Fall '20
  • MYSQL , administrator, Sun Microsystems, InnoDB, MyISAM

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes