최신 MYSQL-Certifications 1Z0-873 무료샘플문제:

1. After a server crash, some InnoDB tables need to be repaired. However, when the server is restarted, auto-recover failed. How would you repair the InnoDB tables?

A) Execute the OPTIMIZE TABLE command.
B) Execute the REPAIR TABLE command.
C) Restart the server with the --innodb_force_recovery option.

2. Which of the following correctly defines the general difference between a read lock and a write lock?

A) A read lock prevents any other client from reading the same data, until the lock is released.
B) A read lock allows other clients to read the same data, however will prevent any modification of the data until the lock is released.
C) A write lock prevents any other client from reading or writing the locked data until the lock is released.
D) A write lock only prevents any other client from modifying the locked data until the lock is released.

3. 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?

A) The binary logs recorded after the backup at 03:00 should be re-applied to make the database file consistent with the state just before the crash.
B) The procedure described is wrong; instead, the mysqlcheck utility should be used and only if that fails should backup copies be restored.
C) The mysql_restore utility should be used to update the server to its last known state.
D) Once the backup files from 03:00 have been restored, there is nothing more that can be done to restore the database files.

4. When you upgrade from one version of MySQL to another which of these steps are considered necessary?

A) Check the MySQL Reference Manual upgrading section and read the parts that concern your upgrade
B) None of the above
C) Stop the MySQL server
D) Backup your databases
E) Install the new version of MySQL on top of the existing version
F) Start the new server

5. Which of the following correctly defines dirty reads, non-repeatable reads and phantom row?

A) A dirty read is a read by one transaction of its uncommitted changes.
B) A non-repeatable read occurs when a transaction performs the same retrieval twice but gets a differentresult each time.
C) A phantom is a row that appears where it was not visible before.
D) A non-repeatable read is a row that appears where it was not visible before.
E) A phantom is a read by one transaction of uncommitted changes made by another transaction.
F) A dirty read is a read by one transaction of uncommitted changes made by another transaction.

질문과 대답: